Question
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?
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 GPAStep 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