Question: Marty’s cousin, Harry Airedale, is the manager of the local pet food producer in Prescott, Where every dog is a king/queen . Old Harry learned early that it doesn’t pay to cater to one sex of dog over the other. Anyway, Marty told his cousin just how impressed he was at the great job you were doing for him, and he thought you would volunteer to help him cost out this new, Meaty Chunky Sweet Smelling All-Pro Old Roy’s Kibbles Dog Food (Did I miss any brand?)

He has gotten, from a secret source, the cost per serving of the top ranked dog foods, plus the number of servings in each can or box, the amount of protein, and the amount of fat in each can/box. He has willingly offered this secret information to you so that you can help him. This file is named, " Final Question 35 " which your kindly professor has sent to you with this final exam. (If you don’t have it be sure to write and request one.)

Okay, so what are you to do with this information? Well, you are to do a multiple regression and to provide to Harry the following:

 A multiple regression that helps to predict future sales of his dog food.

 An F and t-tests to tell Harry if any of the individual variables are significant.

 What percentage of the total variation did this regression predict, and how do you know?

 Does multicollinearity exist for any of the independent variables, and if so, which one(s)?

 And figure out any other statistical tests that you would run to make both Harry and Marty go away.

Plus you have to give Harry the potential selling price , based on this regression, for the following different ingredients and packing sizes.

Plus, if this wasn’t enough for free work, you are to briefly tell Harry the impact of more versus less cups/servings, and more versus less protein and fat on overall cost. Also remember, just for people, fat is bad for dogs, protein is good!

Price: $2.99

Solution: The downloadable solution consists of 5 pages
Deliverable: Word Document