1)

PART A The following table shows quarterly sales (in thousand units) for a product over 5 years. The overall sales average for the entire 5 years is 133 (thousand units). Fill in the missing values assuming there is no trend. Round seasonal indexes to 4 decimal places. Report Averages accurate to at most 2 decimal places. Report Actual sales ('000) accurate to the nearest integer. Year Year Year Seasonal Year 3 Year 5 Average 1 2 4 Index Quarter 208 187 201 189 210 Quarter 107 95 93 111 0.7789 2 Quarter 55 59 59 51 53 3 Quarter 172 194 164 172 1.3083 4PART B Suppose actual quarterly sales (in thousands) for Year 6 are 218, 105, 51, and 181 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 6. Use seasonal indexes (rounded to 4 decimal places) from Part A. Report forecast answers as integers accurate to the nearest thousand. Quarter 1 forecast = thousand Quarter 2 forecast = thousand Quarter 3 forecast = thousand Quarter 4 forecast = thousand Calculate the mean absolute percent error (MAPE) for the four forecasts. Use the integer forecast values you reported above. Report MAPE as percent accurate to 2 decimal places. Do not round intermediate values. MAPE =A researcher is studying the factors related to the popularity of new music artists, In particular, she is interested in assessing the extent to which the number of albums sold (thousands) is explained by the number of YouTube views (millions) the artists currently have, their number of Facebook fans (millions), and the number of weeks they did not make the coveted J's Top 50 list in the last 12 months. A random sample of 57 popular new artists was collected (see partial data in the following table). New YouTube views Facebook fans Weeks off Albums sold Artist (millions) (millions) Top 50 ('000) 1 220.77 5.29 34.5 60.183 IN 210.52 6.09 34.8 58.928 247.98 9.98 23.5 70.12 The researcher used software to generate a multiple linear regression output for the data. The results are shown below (some values are missing). a) Determine the missing values. Report answers accurate to at least 5 decimal places where necessary. Do not round intermediate results. Multiple R R Square Adjusted RZ Standard Error Observationsdf 5S MS F Regression 28823.0037 9607.6679 Residual 53 1840.6917 Total 56 Coefficient Standard Error t-stat p-value Intercept 12.115603 -1.1964 0.2368 YouTube 0.271846 24.0444 0.0000 Facebook 2.096208 0.347519 0.0000 Top 50 0.304901 0.16929 0.8662 b) What percent of the variation in the dependent variable is not explained by the independent variables in this model? Round percent to 1 decimal place % c) Use the regression coefficients from the output to estimate the number of albums sold (units) for a new artist with 26 million YouTube views, having 2,566,685 Facebook fans, and with exactly 2.4 months off JJ's Top 50 list. [Hint: 1 year = 52 weeks]d) Suppose the regression equation from the output is used to predict the number of albums sold by a new artist to be 41,871. If the artist has 153 million YouTube views and has successfully made JJ's Top 50 list 27.5% of the time in the last 12 months, how many Facebook fans (in thousands) does the artist have? Round to the nearest thousand