Get help with BUSI650 Business Analytics Assignment

BUSI650 Business Analytics

Assignment 2 and 3: Individual Predictive Model and Analytical Decision Making

Sections: 20, 29, and 36

Instructor: Mirza Zaeem Baig

Maximum Marks: 20 Marks

Assignment Deadline: 11:59 PM, Saturday, 10 June 2023

Student Name:                                                           Student ID:

Assignment Description:

You are provided with a regression dataset which shows data on average US annual consumption (in $) and disposable income (in $) for the years 2000 to 2016. Using this dataset perform a regression analysis in MS Excel.                                                                                                                                                

Part A:                                                                                                                       (10 Marks)

Perform the following tasks:

Perform simple linear regression for the dataset provided and produce the results sheet in Excel.                                                                                                                (5 Marks)

Student Output Screenshot(s): Copy the screenshot of the output here.

Describe your result in your own words. Also, find the sample linear regression equation for the model.                                                                                                   (5 Marks)

Answer:

Part B:                                                                                                                        (10 Marks)

Write an analysis/summary report of your regression analysis conducted in Part A. Provide examples of what decisions can be made for the dependent variable based on a given value of an independent variable. For example, what is the predicted consumption if the disposable income is $33,000?                                                            

Answer:

Submission Instructions:

Submit your answers in this Word file by renaming it in the format “BUSI650_Assignment 2 and 3_Student ID” and uploading it on Moodle in the appropriate submission link.

Also, submit the MS Excel file containing the results for Part A.

Please conform to the naming convention of the file.

The post Get help with BUSI650 Business Analytics Assignment first appeared on Punjab Assignment Help.