Solve the given problem. Show solutions if solved manually or show the Excel computation results. PROBLEM : The amount spent on medical expenses per day is correlated with other health factors for 5 adult males. A study came up with the following table: Medical amount spent cost for alcohol weight Age 2100 200 185 50 2378 250 200 42 1657 100 175 37 2584 200 225 54 2658 250 220 32 1. Which of the factors has a significant effect on medical expenses? 2. Create the regression equation for the problem.
Solve the given problem. Show solutions if solved manually or show the Excel computation results.
PROBLEM :
The amount spent on medical expenses per day is
Medical amount spent
cost for alcohol weight Age
2100 200 185 50
2378 250 200 42
1657 100 175 37
2584 200 225 54
2658 250 220 32
1. Which of the factors has a significant effect on medical expenses?
2. Create the regression equation for the problem.
Step by step
Solved in 2 steps with 1 images