Question
business mathematics: Simple Linear Regression The data below was collected from 36 Business Mathematics students in 2023. You have to analyze data about the predictability
business mathematics: Simple Linear Regression
The data below was collected from 36 Business Mathematics students in 2023. You have to analyze data about the predictability of weight from their height. Column 1 shows height in centimeter (x) and column 2 shows weight in kilogram (y). You must run a simple linear regression in excel and answer the questions below:
Height (cm) | Weight (kg) |
167.12 | 51.23 |
181.01 | 62.11 |
176.06 | 69.08 |
173.45 | 65.33 |
172.34 | 65.4 |
175.56 | 56.22 |
177.09 | 64.23 |
178.41 | 62.18 |
172.47 | 51.24 |
170.06 | 55.03 |
169.06 | 58.26 |
172.09 | 52.34 |
173.07 | 57.06 |
170.66 | 56.77 |
173.44 | 53.11 |
180.63 | 63.46 |
169.8 | 59.1 |
174.55 | 65.33 |
172.26 | 57.05 |
179.32 | 61.78 |
182.37 | 63.54 |
175.79 | 58.39 |
169.67 | 64.31 |
171.86 | 54.98 |
172.24 | 59.57 |
162.69 | 48.39 |
174.17 | 56.4 |
165.56 | 56.63 |
176.94 | 63.34 |
172.64 | 62.3 |
167.59 | 48.28 |
174.42 | 58.39 |
169.88 | 66.07 |
171.96 | 52.98 |
177.34 | 65.13 |
175.49 | 61.19 |
Questions:
Instruction in Excel:
Add in Analysis Tool pack: open excel work sheet File > option > Add -ins > Excel Add in > go > Analysis Tool Pack (add in) > ok
Run Regression:
Note: Please attach printout of summary output, line of best fit with equation in it.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started