# Question

The file Catalog Marketing.xlsx contains recent data on 1000 HyTex customers.

a. Create a pivot table of average amount spent versus the number of catalogs sent. Is there any evidence that these two variables are related? Would it make sense to enter Catalogs, as is, in a regression equation for Amount Spent, or should dummies be used? Explain.

b. Create a pivot table of average amount spent versus History. Is there any evidence that these two variables are related? Would it make sense to enter History, as is, in a regression equation for Amount Spent, or should dummies be used? Explain.

c. Answer part b with History replaced by Age.

d. Base on your results from parts a through c, estimate an appropriate regression equation for Amount Spent, using the appropriate forms for Catalogs, History, and Age, plus the variables Gender, Own Home, Married, and Close. Interpret this equation and comment on its usefulness in predicting Amount Spent.

a. Create a pivot table of average amount spent versus the number of catalogs sent. Is there any evidence that these two variables are related? Would it make sense to enter Catalogs, as is, in a regression equation for Amount Spent, or should dummies be used? Explain.

b. Create a pivot table of average amount spent versus History. Is there any evidence that these two variables are related? Would it make sense to enter History, as is, in a regression equation for Amount Spent, or should dummies be used? Explain.

c. Answer part b with History replaced by Age.

d. Base on your results from parts a through c, estimate an appropriate regression equation for Amount Spent, using the appropriate forms for Catalogs, History, and Age, plus the variables Gender, Own Home, Married, and Close. Interpret this equation and comment on its usefulness in predicting Amount Spent.

## Answer to relevant Questions

The file P10_48.xlsx contains monthly sales and price of a popular candy bar.a. Describe the type of relationship between price and sales (linear/nonlinear, strong/weak).b. What percentage of variation in monthly sales is ...Repeat Problem 51 with the football data in the file P03_57.xlsx. a. Rearrange the data so that there are four long columns: Team, Year, Salary, and Wins. There should be 6*30 values for each. b. Create a scatter plot of ...In the world of computer science, Moore’s law is famous. Although there are various versions of this law, they all say something to the effect that computing power doubles every two years. Several researchers estimated ...In a study published in 1985 in Business Horizons, Platt and McCarthy employed multiple regression analysis to explain variations in compensation among the CEOs of large companies. Their primary objective was to discover ...The file P02_10.xlsx contains midterm and final exam scores for 96 students in a corporate finance course. Based on a regression equation for the final exam score as a function of the midterm exam score, find a 95% ...Post your question

0