Blog

Use the ChainSupermarketsA dataset. Create a pivot table. Based on the pivot table, which city has the lowest total transactions?

If all forecast errors are positive, which of the following statements must be true?

Use the RestaurantTraffic Sheet. Use a multiple regression model to estimate daily visitors to a restaurant that is open Monday through Friday. You will need to account for: Day-of-week seasonal effect. Use Monday as your baseline. Time (a period variable, which increases by 1 each day) to capture the overall trend over time. What is the value of the coefficient on Thursday? One decimal place.

Use the InsurancePremium sheet. Develop a multiple linear regression model to predict the monthly car insurance premium based on the age of the driver and the type of car (sedan, SUV, or sports car). Use sedan as the baseline. What is the estimated monthly insurance premium for a 26-year-old driver with a sports car? Please round your answer to the nearest integer.

[Continued] Use the Enrollment sheet. Based on your regression model from the previous question, what is the predicted enrollment in Year 18? One decimal place.

[Continued] Use the Enrollment sheet. Based on your regression model from the previous question, what is the predicted enrollment in Year 18? One decimal place.

At the Nevermore Library, study sessions average 52 minutes with a standard deviation of 8 minutes. The session duration follows a normal distribution. Using the empirical rule, what percentage of sessions last between 36 minutes and 76 minutes? Please answer in one decimal place without the % mark.

Suppose we run the following linear regression model: BloodPressure = b0 + b1*BodyWeight + b2*PotassiumIntake, where BodyWeight is measured in lbs, and PotassiumIntake is the average daily potassium consumption (mg/day).   We find that b1​ is positive (higher body weight increases blood pressure) and b2​ is positive (higher potassium intake raises  blood pressure). Assume that BodyWeight and PotassiumIntake are negatively correlated (individuals who eat more potassium-rich foods like fruits and vegetables tend to have lower body weight). If PotassiumIntake were omitted from the model and only BodyWeight were included, would you expect the estimated coefficient on BodyWeight to be larger or smaller than the b1​ estimated when PotassiumIntake is included? Explain briefly. Note: Use your understanding of regression analysis to answer this question. When answering, be sure to first state whether you expect the coefficient to become larger or smaller, and then explain why in your own words.

If all forecast errors are negative, which of the following statements must be true?

In regression analysis, we use the t-test’s p-value to determine whether the coefficient on a variable is statistically different from ________.