please answer the hw problems in the attached file. Use MS Excel to seek appropriate solutions to the two problems.

Module 7 Home Work Problems Q1: Cost Estimation Rock n Roll Heaven is an outdoor pavilion that presents musical performers throughout a 6-month season, from late spring to early fall. Rock n Roll presents a diverse venue of artists in a set of approximately 40 events each season. In order to better project its costs and expected attendance, Rock n' Roll uses regression analysis to project expected ticket sales for upcoming events for each performer. The regression results shown below are derived from the three most recent seasons. The dependent variable for Rock n Roll is the number of paying tickets holders for each event, and the independent variables are: 1. whether or not this particular performer appeared at Rock n Roll previously (a dummy variable, 0 if no and 1 if yes) 2. the spending on advertising targeted to the performer's appearance 3. the performer's local sales of CDs in the most recent year prior to their appearance 4. the number of television appearances for the performer in the most recent year 5. the number nf nuhlio anmown- U.S. by the performer in the recent year Required: 1. Using the above regrewsion, what attendance would be prediced for a performer who had appeared at Rock n ' Roll previously, had 6 other public appearances but no TV appearances, CD sales of $10 million, and Rock n Roll planned to spend $35,000 on advertising? (Hint: y=a+v11+v22+v33+v44+v55 ) 2. Evaluate the precision and reliability of the regression results shown above. What changes if any, do you propose for the regression? Which variables should be deleted, and which do you think should be added, and why? Q2: Cost Estimation, High-Low Method, Regression Analysis Lexcon, Inc is a large manufacture of affordable DVD players. Management recently became aware of rising costs resulting from returns of malfunctioning products. As a starting point for further analysis, Paige Jennings, the controller, wants to test different forecasting methods and then use the best one to forecast quarterly expenses for 2013 . The relevant data for the previous three years is as follows: The result of a simple regression analysis using all 12 data points yielded the following: 1. Calculate the quarterly forecast for 2013 using the high-low method and show graphical representation. Also, use simple and multiple regression analysis. For multiple regression, add a dummy variable of seasonality based on a visual representation of the data. Recommend which method Paige should use (Hint: quarters must be numbered sequentially like 1,2,3,4,5,6 11,12.13... without repeating any numbers). 2. How does your analysis in requirement one above change if Lexon manufactures its products in multiple global production facilities to serve the global market? Module 7 Home Work Problems Q1: Cost Estimation Rock n Roll Heaven is an outdoor pavilion that presents musical performers throughout a 6-month season, from late spring to early fall. Rock n Roll presents a diverse venue of artists in a set of approximately 40 events each season. In order to better project its costs and expected attendance, Rock n' Roll uses regression analysis to project expected ticket sales for upcoming events for each performer. The regression results shown below are derived from the three most recent seasons. The dependent variable for Rock n Roll is the number of paying tickets holders for each event, and the independent variables are: 1. whether or not this particular performer appeared at Rock n Roll previously (a dummy variable, 0 if no and 1 if yes) 2. the spending on advertising targeted to the performer's appearance 3. the performer's local sales of CDs in the most recent year prior to their appearance 4. the number of television appearances for the performer in the most recent year 5. the number nf nuhlio anmown- U.S. by the performer in the recent year Required: 1. Using the above regrewsion, what attendance would be prediced for a performer who had appeared at Rock n ' Roll previously, had 6 other public appearances but no TV appearances, CD sales of $10 million, and Rock n Roll planned to spend $35,000 on advertising? (Hint: y=a+v11+v22+v33+v44+v55 ) 2. Evaluate the precision and reliability of the regression results shown above. What changes if any, do you propose for the regression? Which variables should be deleted, and which do you think should be added, and why? Q2: Cost Estimation, High-Low Method, Regression Analysis Lexcon, Inc is a large manufacture of affordable DVD players. Management recently became aware of rising costs resulting from returns of malfunctioning products. As a starting point for further analysis, Paige Jennings, the controller, wants to test different forecasting methods and then use the best one to forecast quarterly expenses for 2013 . The relevant data for the previous three years is as follows: The result of a simple regression analysis using all 12 data points yielded the following: 1. Calculate the quarterly forecast for 2013 using the high-low method and show graphical representation. Also, use simple and multiple regression analysis. For multiple regression, add a dummy variable of seasonality based on a visual representation of the data. Recommend which method Paige should use (Hint: quarters must be numbered sequentially like 1,2,3,4,5,6 11,12.13... without repeating any numbers). 2. How does your analysis in requirement one above change if Lexon manufactures its products in multiple global production facilities to serve the global market