(Quantitative Methods)

(Quantitative Methods) Paper details: Details: Review "Multiple Regression Models Case Study: Web Video on Demand" (Attached Lin" rel="nofollow">ink) for this topic's case study, predictin" rel="nofollow">ing advertisin" rel="nofollow">ing sales for an Internet video-on-demand streamin" rel="nofollow">ing service. 1.) Submit a copy of the Excel spreadsheet file you used to design your regression model and to determin" rel="nofollow">ine statistical significance. *******Note: Students should use Excel's regression option to perform the regression. Apply all Excel file calculation and explanations. Cells should contain" rel="nofollow">in the formulas (i.e., if a formula was used to calculate the entry in" rel="nofollow">in that cell). Use the "Multiple Regression Dataset" Excel resource to complete this assignment.******* 2.) After developin" rel="nofollow">ing both Regression Model A and Regression Model B, prepare a 250-500-word executive summary of your fin" rel="nofollow">indin" rel="nofollow">ings on a word document. Please explain" rel="nofollow">in your approach and evaluate the outcomes of your regression models. Multiple Regression Models Case Study: Web Video on Demand Web Video on Demand (WVOD) is an Internet video-on-demand streamin" rel="nofollow">ing service. The company offers a subscription service for $5.99/month, which in" rel="nofollow">includes access to all programmin" rel="nofollow">ing and 30-second commercial in" rel="nofollow">intervals. In the last year, the company has recently begun producin" rel="nofollow">ing its own programmin" rel="nofollow">ing, in" rel="nofollow">includin" rel="nofollow">ing 30-, 60-, and 120-min" rel="nofollow">inute television shows, specials, and films. Programmin" rel="nofollow">ing has been developed for teen audiences as well as adults. The followin" rel="nofollow">ing data represent the amount of money brought in" rel="nofollow">in through advertisin" rel="nofollow">ing sales, the average number of viewers, length of the program, and the average viewer age per program. Advertisin" rel="nofollow">ing Sales ($) Average # of Viewers (Millions) Length of Program (Min" rel="nofollow">inutes) Average Viewer Age (Years) 28,000 10.1 30 30 25,500 11.4 30 25 31,000 19.9 60 30 29,000 13.6 60 38 20,500 12.5 60 20 14,500 3.5 30 15 27,000 15.1 60 24 23,500 3.7 30 17 19,500 4.3 30 19 23,000 12.2 120 45 18,000 5.1 120 19 29,500 15.9 60 28 30,000 16.8 120 31 25,000 8.5 120 58 22,500 9.1 30 43 The WVOD executives are in" rel="nofollow">in the process of evaluatin" rel="nofollow">ing a partnership with several in" rel="nofollow">independent filmmakers to fund and distribute socially conscious and diverse programmin" rel="nofollow">ing. The executives have asked for regression models to be developed based on specific needs. The three regression model requests and programmin" rel="nofollow">ing details are in" rel="nofollow">included below. The WVOD executives would like to see a regression model that predicts the amount of advertisin" rel="nofollow">ing sales based on the number of viewers and the length of the program. Develop this regression model (“Regression Model A”). Web Video on Demand would like to acquire a 60-min" rel="nofollow">inute documentary special about social media and bullyin" rel="nofollow">ing. The special is aimed at teen viewers and is estimated to brin" rel="nofollow">ing in" rel="nofollow">in 3.2 million viewers. Based on the regression model, predict the advertisin" rel="nofollow">ing sales that could be generated by the special. The WVOD executives would also like to see a regression model that predicts the amount of advertisin" rel="nofollow">ing sales based on the number of viewers, the length of the program, and the average viewer age. Develop this regression model (“Regression Model B”). Web Video on Demand may acquire a 2-hour film that was a hit with critics and audiences at several in" rel="nofollow">international film festivals. Initial customer surveys in" rel="nofollow">indicate that the film could brin" rel="nofollow">ing in" rel="nofollow">in 14.1 viewers and the average viewer age would be 32. Use this in" rel="nofollow">information to predict the advertisin" rel="nofollow">ing sales.