YearQuartertYYear 11121.18 2221.47 3321.95 4421.58Year 21522.39 2622.87 3723.48 4823.66Year 31924.1 21023.99 31124.54 41224.3Year 411325 21425.64 31526.36 41626.98Year 511727.52 21827.78 31928.24 42029.38

1. Be sure to SHOW ALL Excel WORK and LABEL the written answers to each question (not just highlighted computer printouts) in order to receive full credit for any correct answers (or partial credit for any incorrect answers). 2. Make a printout of your excel output and staple it to your answers. 3. Write out the answers separately from the Excel output. 4. Be sure to state all null and alternative hypotheses when appropriate. 5. You may look things up in Basic Business Statistics 11e, your class notes, and in the help system of Excel. No other material is allowed. 6. No group work is allowed. I expect the work you turn in to be your own, and that you have not received help from anyone. If I find evidence to the contrary, I will follow university regulations for reporting it. The General Nutrient Corporation (GNC) sells various types of vitamin supplements in a regional market. The accompanying data show quarterly GNC sales in millions of dollars (Y) for a 5-year period. (data on blackboard) In statistics, time is many times used as an explanatory variable in order to estimate any long- term trend which may be contained within a time series variable. A trend is any long-term steady increase or decrease in a variable over time and may be used to forecast future values of a time series variable. Use the data provided on blackboard to answer the following questions dealing with trend analysis: a .Plot the GNC Sales (Y) against the time variable (t). Do you see any evidence of a trend? Explain b. Use Excel to find the estimated coefficients for the linear trend equation: Y = 0 + 1t + error. Interpret the slope. c. Comment on the significance of the slope coefficient. Should we include the time variable t in the model? Explain. d. Comment on the goodness of fit of the model. e. Forecast GNC Sales for the first two quarters of Year 6.