fbpx

Business Research | Homework Help Websites

Assignment 9: Excel & SPSS Linear Regression Analysis

Don't use plagiarized sources. Get Your Assignment on
Business Research | Homework Help Websites
Just from $13/Page
Order Now

Overview

1. In the first part an example shown for this analysis using the GPAvsGMAT.xls data.

2. In the second part you have to repeat the same steps to for the IQvsGPA.xls

3. You have to provide the same screenshots and results as in the examples that I provided.

1.1. Simple Regression in Excel 2010, 2013, & 2016

To get the Data Analysis tool, first click on File > Options > Add-Ins > Go > Select Data Analysis Toolpack & Toolpack VBA. Data Analysis is now available under Excel’s Data tab. Open the Excel Worksheet GPAvsGMAT.xls and select Data Analysis > Regression. Then fill out the popup window as shown below, specifying GPA as the Y variable and GMAT as the X variable:

This will produce the output:

SUMMARY OUTPUT

Regression Statistics

Multiple R 0.8086001

R Square 0.6538342 Adjusted R Square 0.6346027 Standard Error 0.4350142

Observations 20

ANOVA

df SS MS F Significance F

Regression 1 6.43372807 6.43373 33.9982 1.59668E-05

Residual 18 3.40627193 0.18924

Total 19 9.84

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

Intercept -1.699561 0.72677682 -2.3385 0.0311 -3.22646284 -0.17266 -3.2264628 -0.17265997

GMAT 0.0083991 0.001440476 5.8308 1.6E-05 0.005372795 0.011425 0.0053728 0.01142545

Note: If you are using Excel 2003 or 2007 version, you get the Data Analysis by following these steps:

1.1b. Simple Regression in Excel 2007

To get the Data Analysis tool in Excel 2007, click on the Office button (top left corner), and select Excell options > Add-Ins > Go > Select Data Analysis Toolpack & Toolpack VBA. Data Analysis is now available under Excel’s Data tab.

 

1.1c. Simple Regression in Excel 2003

To get the Data Analysis tool in Excel 2003, select Tools > Add-Ins > Select Data Analysis Toolpack & Toolpack VBA. Regression analysis is then available under Tools > Data Analysis

 

> Regression.

1.2 Repeat these steps for the data of IQvsGPA.xls.

1.2.1 Provide your output as shown above. (12.5 points)

In the second part you have to repeat the same steps to for the IQvsGPA.xls

You have to provide the same screenshots and results as in the examples that I provided.

1.2.2

2. Simple Regression in IBM SPSS.

2.1 Start IBM SPSS Statistics 21, available from the Statistics menu of the standard COB PC configuration. Select File > Open > Data. Select to see Files of type: Excel. Open GPAvsGMAT.xls. Confirm that variable names should be read from the first row of data.

2.1.1 Select Analyze > Regression > Linear. Specify Dependent=GPA, Independent=GMAT.

Select OK.

This will produce the following output:

Regression

Variables Entered/Removed b

Model Variables Entered Variables Removed Method
1 GMAT a . Enter

a. All requested variables entered.

b. Dependent Variable: GPA

Model Summary

Model R R Square Adjusted R Square Std. Error of the Estimate
1 .809 a .654 .635 .4350

a. Predictors: (Constant), GMAT

ANOVAb

Model Sum of Squares df Mean Square F Sig.
1 Regression 6.434 1 6.434 33.998 .000(a)
Residual 3.406 18 .189
Total 9.840 19

a. Predictors: (Constant), GMAT

b. Dependent Variable: GPA

Coefficientsa

Model Unstandardized Coefficients Standardized Coefficients t Sig.
B Std. Error Beta
1 (Constant) GMAT -1.700

.008

.727

.001

.809 -2.338

5.831

.031

.000

a. Dependent Variable: GPA

2.2. Repeat these steps for the data of IQvsGPA.xls. Provide your output as shown above. (12.5 points)

In the second part you have to repeat the same steps to for the IQvsGPA.xls

You have to provide the same screenshots and results as in the examples that I provided.

 

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
History
Extremely well written, perfect for what I needed
Customer 454393, May 21st, 2020
Management
support is great. I am grateful to you and your company. thank you very much.
Customer 454227, April 6th, 2020
Nursing
The paper was delivered on time but I requested for a revision. Overall, it was on time and satisfied with the provided 2 versions of the revised paper. Thank you!
Customer 454455, June 7th, 2020
Science
Good one.
Customer 453625, May 21st, 2022
Nursing
nice work
Customer 453939, June 8th, 2020
Economics
I would like to thank you for your hard work. The essay is clear and clean.
Customer 462687, March 14th, 2022
Psychology
Good work.
Customer 459817, June 23rd, 2022
Business
Good work!
Customer 463469, October 29th, 2022
Home Repair & Home Maintenance
Great work
Customer 452441, April 21st, 2022
Communications
The best writer. Thank you!
Customer 462787, August 1st, 2022
Business
Great content! Few modification done
Customer 463245, December 15th, 2022
Nursing
paper was not completed by due date
Customer 454371, May 25th, 2020
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat