# November 2023 mod 3 dq1 What types of business situations or problems might best lend themselves to simple linear regression

Jamie24 week 3

mod 3

dq1 What types of business situations or problems might best lend themselves to simple linear regression and what types may not? Why and why not?

dq2 A health researcher is interested in determining whether or not the speed at which people walk is related to their cholesterol levels. He picks 100 adult volunteers at random, checks their cholesterol levels, and then times each one while they walk a stretch of 100 yards. He is amazed at the results: a simple regression between the walk times and the cholesterol levels has an R2 of 0.98 and the slope of the regression line is 0.7. Would he be justified in concluding that walking slowly may cause high cholesterol or that high cholesterol may affect walking speed? Discuss why or why not.

Assignment:

Complete Problems 4-13, 4-14, 4-15, and 4-19.

Use Excel’s regression option to perform the regression.

Use an Excel spreadsheet file for the calculations and explanations, with one worksheet per problem. Use the problem number for each worksheet name. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell).