1. Learn
    2. /
  2. Courses
    3. /
  3. Analyzing Survey Data in Python

Exercise

Safety precautions needed?

A store is trying to determine if they need to upgrade their safety protocol based on the number of buyers they expect to have on Black Friday 2023, the biggest sales event of the year. Their maximum occupancy limit is 250. Every year on Black Friday, this store surveys each buyer to rate their shopping experience and you happen to get your hands on the data.

The survey dataset, foot_traffic, has been cleaned and loaded for you. It consists of columns: year, visitors, and average_experience_rating.

The statsmodels.api package has been imported as sm, along with matplotlib.pyplot as plt, pandas as pd, and numpy as np.

Instructions 1/3

undefined XP
    1
    2
    3
  • Find the slope and y-intercept values for the regression line between total buyers and year using the OLS regression method.