Using the excel files attached Read the questions the assignment below and use the Excel data files to complete the analyses. The instructions, are also below the assignment here..

Question 1: The Shopping Center Parking

The data file Shopping Center Parking.xlsx contains the number of cars parked each day both in the outdoor lot and in the parking garage near a shopping center.

Please find out the correlation between the number of cars parked in the outdoor lot and in the parking garage.

Instruction:

You need to run correlation analysis for question 1 and 2.

• For "the Shopping Center Parking," the dataset includes two variables, which are "the number of cars parked each day in the outdoor lot" and "the number of cars packed each day in the parking garage." You need to run a correlation analysis.

• For "the HP Printer," the dataset includes three variables.

o Correlation analysis aims to determine the directionality and strength of variables, regardless of the measurements, units, and coding methods. That is, although the variables are measured in "units" or "profits," the results stand legitimate.

o Because the template only support running two variables at one time, you need to run three correlation analyses (assuming the names of variables are A, B, and C):

 1 - A and B;

 2 - B and C;

 3 - A and C.

o The reason for us to use the template instead of the Excel build-in function is that the Excel function does not report the p-value for correlation analysis.

How to report the results?

• Please see the sample of reporting as below (the format does not need to the same as the sample):

o There are (.....) cases in the data set.

o The p value of the correlation analysis is (.....), which is greater (or less) than 0.05. It indicates that there is (not) a statistically significant correlation between (variable 1) and (variable 2).

o The correlation coefficient (r) is (.....)1, meaning that there is a strong (or moderate, weak) negative (or positive) correlation between (variable 1) and (variable 2).

• The strength of correlation can be found in slide 20.

• The p-value of a correlation analysis must be less than .05 in order to indicate the existence of a statistically significant correlation.