Using excel, I need a simple linear regression equation to help define the relationship between height...
Using excel, I need a simple linear regression equation to help define the relationship between height and weight using the table below. Using that equation, I need to predict the weight for a height of 5.75 inches.
| Height (in feet) | Weight (in pounds) |
| 4.8 | 115.10 |
| 4.9 | 117.11 |
| 5.0 | 120.11 |
| 5.1 | 123.11 |
| 5.2 | 126.10 |
| 5.2 | 129.12 |
| 5.3 | 132.12 |
| 5.4 | 135.12 |
| 5.5 | 139.13 |
| 5.6 | 142.13 |
| 5.7 | 146.12 |
| 5.7 | 150.13 |
| 5.8 | 154.15 |
| 5.9 | 159.15 |
| 6.0 | 164.16 |
Homework Answers
| Height (X) | Weight (Y) | X * Y | X2 | Y2 | |
| 4.8 | 115.1 | 552.48 | 23.04 | 13248.01 | |
| 4.9 | 117.11 | 573.839 | 24.01 | 13714.75 | |
| 5 | 120.11 | 600.55 | 25 | 14426.41 | |
| 5.1 | 123.11 | 627.861 | 26.01 | 15156.07 | |
| 5.2 | 126.1 | 655.72 | 27.04 | 15901.21 | |
| 5.2 | 129.12 | 671.424 | 27.04 | 16671.97 | |
| 5.3 | 132.12 | 700.236 | 28.09 | 17455.69 | |
| 5.4 | 135.12 | 729.648 | 29.16 | 18257.41 | |
| 5.5 | 139.13 | 765.215 | 30.25 | 19357.16 | |
| 5.6 | 142.13 | 795.928 | 31.36 | 20200.94 | |
| 5.7 | 146.12 | 832.884 | 32.49 | 21351.05 | |
| 5.7 | 150.13 | 855.741 | 32.49 | 22539.02 | |
| 5.8 | 154.15 | 894.07 | 33.64 | 23762.22 | |
| 5.9 | 159.15 | 938.985 | 34.81 | 25328.72 | |
| 6 | 164.16 | 984.96 | 36 | 26948.51 | |
| Total | 81.1 | 2052.86 | 11179.54 | 440.43 | 284319.2 |
Equation of regression line is Ŷ = a + bX
b = ( 15 * 11179.541 - 81.1 * 2052.86 ) / ( 15 * 440.43 - ( 81.1
)2)
b = 41.251
a =( Σ Y - ( b * Σ X) ) / n
a =( 2052.86 - ( 41.2506 * 81.1 ) ) / 15
a = -86.171
Equation of regression line becomes Ŷ = -86.1712 + 41.2506
X
When X = 5.75
Ŷ = -86.171 + 41.251 X
Ŷ = -86.171 + ( 41.251 * 5.75 )
Ŷ = 151.02
Using excel -----> Data tab -----------> Data Analysis option -------> Regression
Add Answer to:
Using excel, I need a simple linear regression equation to help
define the relationship between height...
24. (Correlation) A researcher wants to determine if there is a linear relationship between height and...
24. (Correlation) A researcher wants to determine if there is a linear relationship between height and weight. The following table represents the data collected. Display the data in a scatter plot on your calculator, draw a quick sketch below. Then find the linear regression and put the line of best fit on the sketch. Then state the value for the correlation coefficient and determine if this is significant correlation or no correlation using the table in the back of the...
please don't copy. thanks Question 3. In a study measuring the height of birch trees, two...
please don't copy. thanks
Question 3. In a study measuring the height of birch trees, two types of fertilizer were used. Prior to the study 14 tree's heights were measured. 8 trees were then selected at random to receive a liquid fertilizer during the first summer of the experiment. At the end of the first year their growth was measured. While this was occurring another 6 trees were receiving a granular fertilizer. At the end first year their height was...
calculations for: concentration of the unknown acid and values for pKa and Ka. Part E: pH...
calculations for:
concentration of the unknown acid and values for pKa and
Ka.
Part E: pH pH pH pH Average Volume Trial 1 Trial 2 Trial 3 5.0 0 5 5.0। 5.1 .0 । 5.1 5.1 5.2 5.3 [5.0। 5.1 5.1 5.1 5.2 5.3 [5.2 5.3 5.3 5.4 5.5 16. 16.5 17.0 | 17.5। 18.0 18.5 19.0 19.5 | 20.0 20.5 21.0 | 21.5 | 22.0 22.5 23.0 23.5 24.0 24.5 | 5.6 5.7 [5.3 [5.4 | 5.5 | 5.6...
Parametirc test or not: Test statistic: p-value: decision: Is There A Difference Between the Means?
Parametirc test or not:Test statistic:p-value:decision:Is There A Difference Between the Means?6.7 6.2 3.1 310.3 10 5 5.56.9 5.5 3.3 3.110.5 6.3 4.3 5.44.5 4.6 1.8 25.6 5.6 2 2.65.9 6.1 2.1 2.58 11.7 4 4.68 7.4 3.3 3.15.8 5.2 3.1 2.96 7.3 3.0 3.28.7 5.3 2.7 36 5.5 2.1 2.27.2 6.3 3.5 3.25.9 4.6 2.9 3.46 7.4 3 3.37.2 7.8 3.7 3.48.6 9.4 5.1 5.77.2 8.1 2.8 3.15.8 5.4 2.2 1.83.3 4 1.7 1.86.8 5.1 2 1.83.7 3.5 2.2 2.112...
11.38 Building a multiple linear regression model. Let’s now build a model to predict the life-satisfaction...
11.38 Building a multiple linear regression model. Let’s now build a model to predict the life-satisfaction score, LSI. (a) Consider a simple linear regression using GINI as the explanatory variable. Run the regression and summarize the results. Be sure to check assumptions. (b) Now consider a model using GINI and LIFE. Run the multiple regression and summarize the results. Again be sure to check assumptions. (c) Now consider a model using GINI, LIFE, and DEMOCRACY. Run the multiple regression and...
PLEASE HELP! I really need help figuring out the h nmr of this product drawn on...
PLEASE HELP! I really need help figuring out the h nmr of this
product drawn on the picture. I’m having some trouble assigning
labels and figuring out multiplicity for each of the peaks. Thank
you so much!! I really appreciate it.
TH NMR of the product in CDCl 1a 1.6 1. 6 74 72 7.0 6.6 66 64 6.2 6.0 5.8 5.6 5.4 5.2 5.0 8 46 44 4.2 40 3.8 3.6 34 3.2 3.0 2.8 26 2.4 2.2 2.0...
lease, i need Unique answer, Use your own words (don't copy and paste). *Please, don't use...
lease, i need Unique answer, Use your own words
(don't copy and paste).
*Please, don't use handwriting.
* i need References URL Link
How would you explain this U-Shaped graph of mental health data
and how can you justify the complexities of the relationship
between our health and our life course
Please, i need Unique answer, Use your own
words (don't copy and paste).
*Please, don't use handwriting.
Please, i need Unique answer, Use your own
words (don't copy and...
I do not need help with a. Thank you for all of your help! Question 2 (30 points) The following table presents shear st...
I do not need help with a. Thank you for all of your help!
Question 2 (30 points) The following table presents shear strengths (in kN/mm) and weld diameters (in mm) for a random sample of spot welds. Diameter Strength 4.2 50.7 5.0 76.4 6.0 102.5 4.3 58.3 5.8 81.0 6.3 98.3 70.5 4.8 5.2 94.7 6.1 102.6 4.9 82.6 a) (6 points) Construct a scatterplot of strength versus diameter. Verify that a linear model is appropriate. b) (6 points)...
Saved 2023 A sample of 100 bank customer waiting times are given in the following table:...
Saved 2023 A sample of 100 bank customer waiting times are given in the following table: Waiting Times (in Minutes) for the Bank Custoner Waiting Tine Case 4.5 9.7 11.8 10.4 4.2 7.e 5.5 8.7 8.8 5.1 5.4 4.5 6.2 3.9 8.7 7.6 4.7 4.0 4.0 10.1 .3 2.8 5.4 6.5 9.7 5.2 7.0 5.8 4.5 8.2 1.9 5.2 4.1 7.9 5.3 8.8 6.2 4.1 4.1 4.5 10.4 .2 7.0 6.8 5.5 8.3 11.3 5.9 8.8 2.8 6.7 5.5 5.e...
any help appreciated! especially checking with what i already have for sig figs! (2) Calculate the approximate random error ∆h = (1/2) [h(max) - h(min)], where h(max) and h(min) are the highest and...
any help appreciated! especially
checking with what i already have for sig figs!
(2)
Calculate the approximate random error ∆h
= (1/2) [h(max) - h(min)], where h(max) and h(min) are the highest
and lowest values of h. ∆h refers to the random error in each
measurement of h.
(3)
Calculate the average hav =
(1/8)[h1 + h2 +…+ h8] and the
error in the average ∆hav = ∆h/√8, of the eight trials.
∆hav gives an overall estimate for the random...
24. (Correlation) A researcher wants to determine if there is a linear relationship between height and weight. The following table represents the data collected. Display the data in a scatter plot on your calculator, draw a quick sketch below. Then find the linear regression and put the line of best fit on the sketch. Then state the value for the correlation coefficient and determine if this is significant correlation or no correlation using the table in the back of the...
please don't copy. thanks
Question 3. In a study measuring the height of birch trees, two types of fertilizer were used. Prior to the study 14 tree's heights were measured. 8 trees were then selected at random to receive a liquid fertilizer during the first summer of the experiment. At the end of the first year their growth was measured. While this was occurring another 6 trees were receiving a granular fertilizer. At the end first year their height was...
calculations for:
concentration of the unknown acid and values for pKa and
Ka.
Part E: pH pH pH pH Average Volume Trial 1 Trial 2 Trial 3 5.0 0 5 5.0। 5.1 .0 । 5.1 5.1 5.2 5.3 [5.0। 5.1 5.1 5.1 5.2 5.3 [5.2 5.3 5.3 5.4 5.5 16. 16.5 17.0 | 17.5। 18.0 18.5 19.0 19.5 | 20.0 20.5 21.0 | 21.5 | 22.0 22.5 23.0 23.5 24.0 24.5 | 5.6 5.7 [5.3 [5.4 | 5.5 | 5.6...
PLEASE HELP! I really need help figuring out the h nmr of this
product drawn on the picture. I’m having some trouble assigning
labels and figuring out multiplicity for each of the peaks. Thank
you so much!! I really appreciate it.
TH NMR of the product in CDCl 1a 1.6 1. 6 74 72 7.0 6.6 66 64 6.2 6.0 5.8 5.6 5.4 5.2 5.0 8 46 44 4.2 40 3.8 3.6 34 3.2 3.0 2.8 26 2.4 2.2 2.0...
lease, i need Unique answer, Use your own words
(don't copy and paste).
*Please, don't use handwriting.
* i need References URL Link
How would you explain this U-Shaped graph of mental health data
and how can you justify the complexities of the relationship
between our health and our life course
Please, i need Unique answer, Use your own
words (don't copy and paste).
*Please, don't use handwriting.
Please, i need Unique answer, Use your own
words (don't copy and...
I do not need help with a. Thank you for all of your help!
Question 2 (30 points) The following table presents shear strengths (in kN/mm) and weld diameters (in mm) for a random sample of spot welds. Diameter Strength 4.2 50.7 5.0 76.4 6.0 102.5 4.3 58.3 5.8 81.0 6.3 98.3 70.5 4.8 5.2 94.7 6.1 102.6 4.9 82.6 a) (6 points) Construct a scatterplot of strength versus diameter. Verify that a linear model is appropriate. b) (6 points)...
Saved 2023 A sample of 100 bank customer waiting times are given in the following table: Waiting Times (in Minutes) for the Bank Custoner Waiting Tine Case 4.5 9.7 11.8 10.4 4.2 7.e 5.5 8.7 8.8 5.1 5.4 4.5 6.2 3.9 8.7 7.6 4.7 4.0 4.0 10.1 .3 2.8 5.4 6.5 9.7 5.2 7.0 5.8 4.5 8.2 1.9 5.2 4.1 7.9 5.3 8.8 6.2 4.1 4.1 4.5 10.4 .2 7.0 6.8 5.5 8.3 11.3 5.9 8.8 2.8 6.7 5.5 5.e...
any help appreciated! especially
checking with what i already have for sig figs!
(2)
Calculate the approximate random error ∆h
= (1/2) [h(max) - h(min)], where h(max) and h(min) are the highest
and lowest values of h. ∆h refers to the random error in each
measurement of h.
(3)
Calculate the average hav =
(1/8)[h1 + h2 +…+ h8] and the
error in the average ∆hav = ∆h/√8, of the eight trials.
∆hav gives an overall estimate for the random...
Most questions answered within 3 hours.
-
This assignment will explore the impact of corporate decisions
on a local versus a global perspective....
asked 3 minutes ago -
Most political philosophers believe we have a duty to obey laws,
even if the laws in...
asked 38 minutes ago -
Which of the following are common negotiation outcome
mistakes?
a. Leave money on the table b....
asked 52 minutes ago -
Propose an efficient synthesis of 2-Bromo-5-nitrotoluene from
benzene. Hint: 3 steps. Consider directing effects of substituents....
asked 59 minutes ago -
Convert the following quantities:
a) 0.819 atm to torr b) 512 mmHg to bar c) 11.2...
asked 1 hour ago -
C ++ Implement cat command
The purpose of this assignment is to provide practice using the...
asked 1 hour ago -
we
convert sugars into another form of stored potential energy. This
is called?
asked 2 hours ago -
The manufacturers of Oriental Spice Sauce are concerned that the
sodium levels in their product vary...
asked 2 hours ago -
PLEASE DON'T ANSWER IF YOU CAN'T ANSWER ALL OF THE QUESTIONS. I
DESPERATELY NEED HELP
Consider...
asked 2 hours ago -
DO NOT ANSWER IF YOU ARE UNSKILLED IN THIS AREA! TYPE OR WRITE
EACH ANSWER CLEARLY!!...
asked 2 hours ago -
how many moles of sodium are there in 3.41 moles of the
following compounds
NaCl
Na2SO4...
asked 2 hours ago -
1.1: Draw a position vs. time graph for a sprinter
running a 100 m dash. Label...
asked 2 hours ago