Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Nipissing University has collected data from a sample 186 members of our alumni. The data include salary of Marketing, HR and Accounting graduates based on

Nipissing University has collected data from a sample 186 members of our alumni. The data include salary of

Marketing, HR and Accounting graduates based on years of experience upon graduation from he

School of Business.

Is there a relationship between GPA and Salary for Accounting students, use a graph to depict this relationship and conduct correlation analysis (10%)?

I have conducted the analysis in Excel and need assistance ensuring I have done it properly as best you can. Here is the output and chart. I have concluded that an R2 value of .0088 indicates is no relationship between GPA and salary. Is my conclusion correct?

image text in transcribedimage text in transcribed
Data Analysis Output Regression Statistics Multiple R 0.093882802 R Square 0.008813981 Adjusted R Square 0.0034271 Standard Error 0.542765755 Observations 186 ANOVA df SS MS F Significance F Regression 1 0.482013962 0.48201 1.63619 0.202459271 Residual 184 54.2054183 0.29459 Total 185 54.68743226 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 2.83701949 0.237945152 11.923 1.2E-24 2.367567853 3.30647113 2.367567853 3.30647113 Accounting Salary 6.45014E-06 5.04257E-06 1.27914 0.20246 -3.49855E-06 1.6399E-05 -3.49855E-06 1.6399E-05Accounting GPA vs Salaries $90,000 $80,000 $70,000 $60,000 $50,000 Accounting Graduate Salary $40,000 $30,000 $20,000 y = 1366.5x + 42236 $10,000 R2 = 0.0088 SO 0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 Accounting Student GPA

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

Students also viewed these Mathematics questions

Question

What is the effect of word war second?

Answered: 1 week ago