Multiple Regression and SPSS Exercise

Description

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.