Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

When reviewing this question and answer. https://www.coursehero.com/tutors-problems/Statistics-and-Probability/38959780-Description-A-downloadable-spreadsheet-named-CV-of-r-was/ I am solving the same problem with same data. At step number one, they use excels regression tool

When reviewing this question and answer. https://www.coursehero.com/tutors-problems/Statistics-and-Probability/38959780-Description-A-downloadable-spreadsheet-named-CV-of-r-was/ I am solving the same problem with same data. At step number one, they use excels regression tool to get the coefficient. The problem says we are to compare age with salary. When I use the regression tool in excel, I select all the salary rows for the Y range. Then for the X range I select all the ages. My confidence interval is set to 95%. But when I click enter, I have different results. What am I doing wrong? My settings:

image text in transcribedimage text in transcribedimage text in transcribed
H C E F G A B D Position Management Level Salary Age Gender Country Race/Ethnicity Department $280,420 40 Male United States White Field Sales Major Account Manager Employee 194 Employee $300,420 195 43 Male United States White Field Sales Major Account Manager $60,420 196 White Sales and Conninlint meloyee 25 Male United States Regression ? X $300,420 197 46 Male United States White Field Sales pyee pyee $60,420 198 24 Male United States White Sales Input Solution Engineers OK byee $170,420 199 44 Male United States White T byee $60,920 200 22 Male United States Technical Support Input Y Range: $H$2:$H$226 White Cancel $60,420 28 Male United States White Sales pyee 201 Input X Range: $A$2:$A$226 byee $95,420 202 26 Male United States White Finance Help byee $88,420 203 25 Male United States Asian Engineering Labels Constant is Zero byee $60,420 204 23 Male United States White Sales 95 byee $300,420 205 43 Male United States White Field Sales Confidence Level: byee $60,420 22 Male White Sales 206 United States Output options bye $125,420 207 30 Female United States White Product Management + byee $280,420 208 42 Male United States White Field Sales Output Range: President $399, 152 209 46 Male United States White Engineering New Worksheet Ply: 1 r Director $270, 151 210 40 Male United States White Engineering 41 Female United States Asian Engineering New Workbook tor $232, 170 211 Field Sales pyee $255,420 212 33 Male United States White Residuals byee $69, 126 213 34 Male United States White Technical Support Residuals Residual Plots pyee $104,920 214 25 Female United States White Product Management Standardized Residuals Line Fit Plots Solution Engineers byee $172,900 215 29 Male United States White Technical Support pyee $90, 164 216 47 Male United States White Normal Probability pyee $106,020 217 28 Female United States White Customer Success Normal Probability Plots byee $104,920 218 38 Male United States White IT $69,280 219 43 Male United States White Technical Support byee Professional Services Employee $136,406 220 United States Black or African American Senior Services Consultant 46 Male $62,735 45 Female United States White IT Senior Desktop Support Technician Employee 221 $117,900 46 Male United States White Professional Services Senior Services Consultant Employee 222 $66,420 223 32 Male United States White Technical Support Technical Support Engineer Employee $50,420 224 23 Male United States IT Desktop Support Specialist Employee Hispanic or Latino Principal Technical Account Manager Employee $152,220 225 36 Male United States Hispanic or Latino Customer Success 48 Male United States White Solution Engineers Solution Engineer Employee $200,420 226 227 228SUMMARY OUTPUT Regression Statistics Multiple R 0518031983 R Square 0.268357136 Adjusted R Square 0.265076226 Standard Error 81765.08582 Observations 225 SUMMARY OUTPUT Regression Statistics Multiple R 0.51803198 R Square 0.26835714 Adjusted R Square 0.26507623 Standard Error 9.72879851 Observations 225

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Engineering Mathematics, Enhanced

Authors: Erwin Kreyszig

10th Edition

1119446848, 9781119446842

More Books

Students also viewed these Mathematics questions