Please submit preliminary report writeup, to Moodle discussion as an attachment in PDF format only. Tables, charts, and graphs should be formatted as expected for the class. Font size of 11 pt or higher. DO NOT SUBMIT YOUR EXCEL DATASET. Copy and paste the numerical prompts below into your submission document and record your responses , as applicable, directly beneath. Include the following in your submission:

Simple Regression Pre-analysis (include ALL charts, graphs and tables you generate formatted to class expectations). Assume all variables (with the exception of the subject variable) are ratio level.

1. YOU MUST HAVE the Data Analysis Tool Pack add-in installed to complete this assignment. Please review the notes for the week regarding how to use the Regression tool within the Data Analysis Tool Pack.

2. Use Excel to calculate and the report the correlation number for all candidate variables for this analysis. Interpret the result of the correlation number by discussing the linear strength and direction of the relations observed .

3. Select 1 variable to use as an explanatory and one as a response variable. State your choices

4. Use Excel to generate and report a scatter plot for the 2 variables. The Explanatory variable should be on the horizontal axis. Interpret the form and direction of the plot. Format chart to class expectations.

5. Using only the visual inspection of the scatter plot, is a transformation warranted? Please review course notes and use what you notice about the dot pattern within the scatter plot as evidence to support your answer.

6. Use the Data Analysis Tool pack to run the regression analysis over your variables to generate a residual plot in MS Excel for these variables. DO NOT INTERPRET NOR REPORT THE NUMERICAL SUMMARIES generated in the regression tables. Only examine the residual plot generated by Excel. Copy and Paste ONLY the residual plot into your preliminary report. Using only your visual inspection of the residual plot, is a transformation warranted? Review course notes and use what you notice about the dot pattern within the residual plot to support your answer.

7. Check the 4 simple regression assumptions (linearity, normality, equal variance, independence). Reference class notes so that you are clear how to perform these checks using the Excel worksheet . Create 4 subheadings to discuss EACH of the 4 assumptions indicating if the assumptions were met or were violated. Under each subheading, also include (or reference by name and number ‘Table 1, Figure 2 etc …) any tables or charts you’ve generated as evidence for your

conclusions. Format all charts and tables to class expectations (see exemplar). Your claims regarding the assumptions must be based on content contained within the tables, numerical summaries , or charts that you generated. Please reference them by name in your write up. For instance “ It can be seen in Figure 1 ….” Etc …

comp.million	sales	no.employees	cap.investment	manufacturing
212	35.0	248.0	10.5	1
226	27.2	156.0	3.8	0
237	49.5	348.0	14.9	1
239	34.0	196.0	5.0	0
242	52.8	371.0	15.9	1
245	37.6	216.0	5.7	0
253	60.7	425.0	18.3	1
262	49.2	285.0	8.0	0
271	75.1	524.0	22.6	1
285	69.0	401.0	12.3	0
329	137.2	947.0	41.4	1
340	140.1	825.0	30.3	0
353	162.9	961.0	36.7	0
384	221.7	1517.0	67.1	1
405	261.6	1784.0	79.2	1
411	300.1	1788.0	79.8	0
456	455.5	2733.0	135.7	0
478	437.6	2957.0	132.7	1
525	802.1	4857.0	278.4	0
564	731.5	4896.0	222.2	1

Answer rating: 100% (QA)

Question a Calculating the correlation for all the independent variables using Excel Data Analysis Correlation compmillion sales noemployees capinvest... View the full answer