PS6 BUS 310|ALL YOU NEED

Problem Set 6 (Ch.13) Individual or group. Use Slipper File Revenue Tab 1. Do a multiple regression using Price ($/per unit), Advertising ($), Bulk Sales to predict Revenue for Slipper House LLC a Slipper manufacturer on Oahu.. Then use the results to predict Revenue on CEI tab with a 95% prediction interval estimate when price is = $ 5.00, Advertising = 3.5, and Bulk sales . Write up a report of your analysis. You should include the following in your report: a. Interpretation of R-squared, Adjusted R-squared, Multiple R, and standard error and what these say about how good the regression is for predicting Revenue from the independent variables. Multiple R = 94.37% - The coefficient correlation has a strong linear relationship in revenue. R Square = 89.05% - 89.05% of variation in revenue is a result of the three independent variables (price, advertising, and bulk sales). Adjusted R Square = 86.31% - Adjusted R Square should be used instead of R Square because there is more than one independent variable. Standard Error = 23.3870 - 23.3870 represents how much variation there is from the predicted revenue. b. Write, the equation (must include Coefficient numbers) - Y= β0 + β1X1 + β2X2 + β3X3 Y = 304.49 - 5.99X1 + 23.69X2 + 98.96X3 c. Next interpretation of the 3 slopes. Which of these variables decrease revenues and which increase revenues? Use the proper units when you do the inter