Please answer the attached
Answer everything using excel.
Sales Forecast: Arabco Dairy, Inc. supplies milk to local grocery stores. Managers at Arabco Dairy hired you to forecast the weekly milk sale. You obtained past data about the number of half gallons of milk sold weekly over the past 12 weeks. The data is provided in the “Milk Sales Data” file posted on campus web. Use this file to answer the following questions: a. Construct a time series plot and comment on it. b. Use the moving average technique to forecast the demand for week 13 using 3-period MA and 5- period MA and comment on your answer. c. Calculate the MAD, MSE, RSME, and MAPE for each forecast in part b. Compare your answers and determine which MA length is better for your forecast. d. Use the simple exponential smoothing technique to forecast the demand for week 13 using a smoothing constant of 0.4 and comment on your answer. e. Calculate the MSE and RSME for your forecast in part d.
Below is the file attached for the above question.
MA and the Financial Market: To smooth out fluctuation in the daily movement in stock prices, moving average technique is used to display stock prices over different periods of time. Get the price of any stock you are interested in and graph it along with its MA such as 7-day MA, 20-day MA, 50-day MA, and 200-day MA. Comment on your graph and explain the difference among the different MA series. A good source of data is https://finance.yahoo.com. It has a lot of financial information, include historical financial data, about public companies. (Using any two MAs of any length is enough for this question)
Banking Data: The “banking Data” file posted on campus web has demographic data for different zip
codes in the bank’s current market. The data includes average bank account balance, median years of
education, median age, median home value, median income, and median household wealth. Use the
stepwise regression to build a good model to predict the average bank account balance based on the
variables included in the data file
Below is the file attached for the above question.
College GPA and SAT Scores: Do you think students’ performance in college is related to their SAT
scores? Some believe so. The admission office at a large state university wants to investigate the
relationship between students’ GPA in their first year in college and their SAT scores. So, they collected
data on students’ first year GPA in college (College GPA), their SAT score (SAT), their high school GPA
(HSGPA), and their race (1 for white, 0 otherwise). The data are in the “College GPA Data” file posted on
campus web. Use this data file to answer the following questions:
a. Build a model to predict students’ college GPA based on their SAT, HS GPA, and race.
b. Use the model to predict the first-year college GPA of a white student with a 3.5 HS GPA and
SAT scores of 1100, 1300, and 1500. Repeat the same prediction for a non-white student.
c. Create two interaction terms: one between SAT and HS GPA and another between SAT and
white and use them to extend the model you built in part a to include these interaction terms.
d. Use the model you built in part c to recalculate the predictions you made in part b
Below is the file attached for the above question
