The excel File Cereal data provides a variety of nutritional…
Question Answered step-by-step The excel File Cereal data provides a variety of nutritional… The excel File Cereal data provides a variety of nutritional information about 67 cereals and their shelf location in a supermarket. Using the correlation and regression analysis tools in Excel, answers the following questions.QUESTIONS:a) Construct and examine the correlation matrix. Using correlation analysis, explain whether multicollinearity a potential problem.b) Suggest an appropriate set of independent variables that predict the level of calories by examining the correlation matrix above.c) Find the best multiple regression model for predicting the level of calories. Keep in mind the principle of parsimony.How good is your model? Does it use the same variables you thought in part (b)d) State the best model equation that predicting the Calories as a function of other variables as you reach in part (c)e) Based from your regression model, list any three types of foods that a person need to avoid to keep his/her level of calories minimum. Image transcription textCereal Data Product Cereal Name Manufacturer Calories Sodium Fiber Carb Sugars 100% Bran Nabisco 70130 10 5 6 2 All-Bran Kellogg 70 260 9 7 5 3 All-Bran w/Extra Fiber Kellogg 50 140 14 8 0 4 Almond DelightRalston Purina 110 200 1 14 8 5 Apple Cinn Cheerios General Mills 110 180 1.50 10.50 10 1 00 6 Ap… Show more… Show more Math Statistics and Probability FINANCE 201 Share QuestionEmailCopy link Comments (0)
