Multiple Regression and SPSS Exercise

This assignment gives you the opportunity to get familiar with multiple regression and basic SPSS functions that are useful and relevant in data analytics. You will practice the following skills that are essential to your success in this course and within this field:

Make data decisions
Data preparation
Conduct multiple regression analysis
Define variables in SPSS
Conduct correlation analysis using SPSS

You can download a Word file of this assignment by clicking the following link – Excel MultiRegression and SPSS Assignment.docx

Instructions

To complete the Machine Learning Excel Multiple Regression and SPSS assignment, follow the instructions below:

Step One – Use the data files retrieved from Module 5 Data Files page:

Median Income
University Data Various Variables
National Universities Rankings

Step Two – Answer the following questions using Excel Multiple Regression Analysis:

Come up with the predictive equation to predict university ranking.
Submit your equation on a Word doc.
Explain how you came up with this equation.
Describe problems or challenges encountered.

Step Three – Use the Cookies Sample 3 Cleaned dataset to perform:

Use SPSS to conduct a correlation analysis of sales (dependent variable) and salesman (independent variable)
Copy SPSS output on Word file. Submit with your explanation of the outputs.