In this assignment, you are expected to complete a mini case study by building a linear regression model based on your own dataset. You can use any dataset you find interesting to you. Ideally, the dataset is real and from your work $($do ask for permission from your employer$).$

Requirements for the dataset used in this case study:

$1.$ It should contain one attribute as the "target" variable you want to predict for $($e$.$g$.,$ Revenue$)$ and two or more attributes that can be reasonable "predictor" variables used to predict the target variable. For example, "Direct Labor Cost" and "Direct Expenses" are two variables that can be reasonably used to predict "Revenue". But "Number of Rocks on the Moon" is not a reasonable predictor for predicting revenue.

$2.$ The number of records $($i$.$e$.,$ the number of rows$)$ in your dataset should be equal to or larger than $5*$ the number of predictors in order to produce reliable modeling outcomes. For example, if your dataset has five predictors, there should be $25$ or more records in the dataset.

$3.$ Meanwhile, although not a requirement, it is ideal that you use a business dataset in this case study.

Some tips about finding your own dataset for the regression case study:

You can use any datasets interesting to you. We prefer it to be a business dataset so that this exercise can help you better understand regression modeling in business applications. There are two ways to find a dataset.

$1.$ First, you can start with a topic you are interested in and follow that to search online for datasets or variables needed to build your regression model.

$2.$ In another method, you can directly search something like "business datasets for regression analysis" from Google search and you will find there are many resources available. From there, you pick the dataset, set a topic, and target the dependent and independent variables for your analysis.

Excel template:

Download and open the Excel VBA program file for the linear regression analysis from HERE. The "Data Sources" tab in the file is blank. Please copy and paste your dataset into this tab. When you paste the dataset, make sure the first row includes all variable names and no white space in any of the names. Meanwhile, there should be no missing values in any of the columns under the variable names.

$2.$

Please complete a simple case study report using the attached report template.

Assignment submission: