Case problem: Selecting a Pcint-and-Shcet Digital Camera Consumer report's tested 20 different point-and-shoot digital cameras. Based upon factors such as the number of megapixels, weight, and price, theyr developed an overall score for each camera tested. The overall score ranges from I] to 10:11 with higher scores indicating better overall test results. The data set includes information on brand, average retail price1 number of megapixels and weig ht. Managerial Report: Use the regression techniq ue1 students need to include the following in their reporL 1} Using overall score as the dependent variable. develop three scatter diagrams. one using price as the independent variable1 one suing weight as the independent variable, and one using the number of megapixels as the independent variable. Which of the three independent variables appears to be the best predictor for overall score? 2} Develop an estimated regression equation that could be used to predict the overall sore given the price of the camera and the number of megapixels. Discuss your ndings. 3} Discuss the need for other independent variables that could be added to the model. IWhat additional variables might be helpful? Observation Brand Price Megapixels Weight Score 1 Canon 330 10 7 66 2 Nikon 200 12 5 66 3 Nikon 130 12 65 Nikon 110 10 62 Canon 270 12 62 Canon 200 12 61 Canon 130 14 60 8 Canon 130 10 60 9 Canon 110 12 59 10 Canon 270 16 55 11 Canon 90 14 52 12 Nikon 400 10 51 13 Nikon 230 12 46 14 Nikon 180 16 65 15 Nikon 80 16 63 16 Nikon 100 14 6 61 17 Nikon 200 14 59 18 Nikon 120 14 57 19 Nikon 170 16 56 20 Nikon 150 12 56