Need statistics help with a discussion and project on height and weight data

User Generated

fgnprlyhi

Mathematics

Description

Discussion & Project with corresponding Excel Spreadsheets.


w7_discussion.docx
w7_project.docx
roi_by_major.xlsx
height_weight_data.xls

Unformatted Attachment Preview

W7 Discussion “Relationship of Height and Weight” Business Statistics Relationship of Height and Weight • • • Using the given Height and Weight data set, follow the steps in the weekly video or on pages 584-585 of the textbook for performing a regression analysis using Excel to analyze the Height and Weight Data set (assume height is the input variable x and weight is the output variable y). Once you have performed the analysis in Excel, state the correct simple linear regression equation and use the regression equation to predict the weight (in pounds) of a person who is 65 inches tall and the weight (in pounds) of a person who is 100 inches tall. Why might the regression equation you have found not be a good predication of the weight of someone who is 100 inches tall? W7 Project Assignment "Project Week 7" Business Statistics Project Week 7 For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. Using the ROI data set: For each of the two majors: 1. Draw the scatter diagram of Y = ‘Annual % ROI’ against X = ‘Cost’. 2. Obtain b0 and b1 of the regression equation defined as y ̂ = b0 + b1X and the coefficient of determination (r2) from the Excel regression output. 3. Draw the fitted regression line on the scatter diagram. 4. Calculate the estimated ‘Annual % ROI’ when the ‘Cost’ (X) is $160,000. 5. Test the hypothesis: o H0: β1 = 0 o Ha: β1 ≠ 0 6. Write a paragraph or more on any observations you make about the regression estimates, coefficient of determination, the plots, and the results of your hypothesis tests. School Type Private Private Private Public Private Public Private Private Private Private Private Private Private Private Private Public Public Private Private Private Best College ROI by Majo 2013: Payscale.com Cost $222.700,00 $176.400,00 $212.200,00 $125.100,00 $212.700,00 $92.910,00 $214.900,00 $217.800,00 $225.600,00 $217.300,00 $226.500,00 $215.500,00 $223.500,00 $226.600,00 $189.300,00 $89.700,00 $87.030,00 $218.200,00 $229.900,00 $148.800,00 30 Year ROI $1.786.000,00 $1.758.000,00 $1.714.000,00 $1.535.000,00 $1.529.000,00 $1.501.000,00 $1.485.000,00 $1.483.000,00 $1.444.000,00 $1.442.000,00 $1.441.000,00 $1.438.000,00 $1.428.000,00 $1.414.000,00 $1.397.000,00 $1.382.000,00 $1.376.000,00 $1.343.000,00 $1.339.000,00 $1.321.000,00 Annual ROI 7,70% 8,40% 7,80% 9,10% 7,40% 10,10% 7,30% 7,20% 7,00% 7,10% 7,00% 7,20% 7,00% 7,00% 7,50% 9,90% 10,00% 6,90% 6,70% 8,10% School Type Private Private Private Private Private Public Private Private Public Private Public Private Public Private Public Public Public Public Private Public Cost $221.700,00 $213.000,00 $230.100,00 $222.600,00 $225.800,00 $87.660,00 $224.900,00 $221.600,00 $125.100,00 $215.700,00 $92.530,00 $217.800,00 $89.700,00 $229.600,00 $101.500,00 $115.500,00 $104.500,00 $69.980,00 $219.400,00 $64.930,00 30 Year ROI Annual ROI $2.412.000,00 8,70% $2.064.000,00 8,30% $1.949.000,00 7,90% $1.947.000,00 8,00% $1.938.000,00 8,00% $1.937.000,00 11,20% $1.915.000,00 7,90% $1.878.000,00 7,90% $1.854.000,00 9,80% $1.794.000,00 7,90% $1.761.000,00 10,60% $1.752.000,00 7,70% $1.727.000,00 10,70% $1.716.000,00 7,50% $1.703.000,00 10,20% $1.694.000,00 9,70% $1.690.000,00 10,10% $1.685.000,00 11,50% $1.676.000,00 7,60% $1.668.000,00 11,70% Height 67 68 67 60 64 61 79 61 71 66 59.5 71 72 55 64 65 65 71 68 71 67 70 68 72 71 65 67 66 63 62 70.5 64 64 69 75 65 67 65 75 57 68 73 68 62 68 73.5 Weight 125 140 142 110 97 106 210 110 150 145 113 175 145 110 112 135 135 140 130 152 127 143 165 160 185 114 116 113 145 116 155 107 104 137 200 150 140 125 240 140 135 178 122 145 190 180 63 72.5 66 68 72 63 65 75 69 72 69 62 64 62.5 78 63 73 69 62.5 63 63 69.5 69 70 60.5 65 72 69 70 67 64 70 71 72 66 65.5 71 68 66.5 67 69 66 71 65 62 65 68 125 165 115 125 210 118 135 225 145 240 170 105 125 130 190 115 280 125 120 145 132 195 168 160 105 112 215 150 150 125 135 185 127 178 123 145 135 135 145 145 193 125 148 125 120 119 160 67 62.5 64 61 62 62.5 70 73 73.5 79 71 63 72.5 69.5 75 62 67 64.5 66 69 60 67 65 66 69 73 73.5 65 67 67.5 62 64 63 65 61 73 74 72 65 73 74 75 70 62 68 57 72 140 115 125 95 126 165 167 250 280 180 175 120 125 156 185 130 140 120 140 155 105 125 115 130 170 247 172 147 160 160 140 120 110 115 115 165 180 182 130 160 190 180 165 140 165 125 160 66 65 63 66 74 64 67 71 60 64.5 61.5 64 66 70.5 69 70 64 62 77 62 69 70 71 71.5 67.5 69 63 65 66.5 67 73 63 73 63 68 69 69 63 64 69 63 64 63 67 71 68 64 128 115 135 118 130 130 140 174 118 133 107 145 150 165 143 155 138 147 245 130 135 150 135 160 110 155 96 140 120 130 155 105 160 112 125 132 175 150 105 135 134 115 123 170 162 140 115 73 67.5 67 60.5 69 65.5 64 76 64 63 62 62 70.5 67 68 71 67 64 70 62 73 79 75 71 65 69.5 205 130 145 125 180 135 140 185 135 127 115 135 142 140 135 178 135 127 153 110 165 165 160 170 117 185
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags