Case problem: Selecting a Point-and-Shoot Digital CameraConsumer reports tested 20 different point-and-shoot digital cameras. Based upon factorssuch as the number of megapixels, weight, and price, they developed an overall score foreach camera tested. The overall score ranges from 0 to 100, with higher scores indicatingbetter overall test results.The data set includes information on brand, average retail price, number of megapixels andweightManagerial Report:Use the regression technique, students need to include the following in their report.1) Using overall score as the dependent variable, develop three scatter diagrams, oneusing price as the independent variable, one suing weight as the independent variable,and one using the number of megapixels as the independent variable. Which of thethree independent variables appears to be the best predictor for overall score?2) Develop an estimated regression equation that could be used to predict the overallsore given the price of the camera and the number of megapixels. Discuss yourfindings.3) Discuss the need for other independent variables that could be added to the model.What additional variables might be helpful?Citation and referencing: Students should follow the APA referencing style to construct theReference List and in-text citations.

fx V A B C D E Observation Brand Price Megapixels Weight Score IN Nikon 170 16 62 W Canon 270 14 61 A Canon 170 10 60 Canon 270 12 60 Nikon 80 14 59 Nikon 100 16 61 00 Nikon 200 14 52 Nikon 120 14 46 10 Canon 170 14 65 11 Canon 270 16 63 12 11 Canon 90 14 46 13 12 Nikon 400 10 65 14 13 Nikon 230 14 & 15 14 Nikon 180 14 65 16 15 Nikon 80 14 & 17 16 Nikon 100 14 61 18 17 Nikon 200 14 59 19 18 Nikon 120 14 57 20 19 Nikon 170 16 56 21 20 Nikon 150 12 56 22 23