Case Study #7:

The data set Cell Phone Service.xls contains hourly data on weather conditions and call performance for a wireless network. The three variables included in the data set are Hour and Pressure: Barometric pressure in inches of mercury at the end of the hour Wind Speed: Wind speed measured in miles per hour at the end of the hour Bad Calls (%): Percentage of bad calls relative to the total number of calls made that hour. Perform a comprehensive analysis to understand what the data tell you about the impact of weather conditions on call performance. Make sure your analysis provides answers to the questions listed below:

1. Obtain the summary statistics for the variables and comment on them.

2. Comment on the distributions of data for the variables? Are they symmetrical? Skewed?

3. Obtain the correlations between variables and comment on them?

4. Perform a multiple linear regression analysis with % of bad call as the response variable and wind speed and pressure as the predictor variables.

5. State the regression equation and interpret the regression coefficients.

6. Comment on the goodness of fit of the regression equation for the data.

7. Explain how you will use the regression equation to predict % bad calls given the wind speed and pressure.

This is only a sample of the data. This data set has over 2000 rows:

table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;}

Hour	Pressure	Wind Speed	Bad Calls (%)
0	29.85	4.6	0.88
1	29.86	3.5	0.86
2	29.86	3.5	0.81
3	29.86	0	0.78
4	29.86	0	0.78
5	29.86	0	0.73
6	29.87	4.6	0.93
7	29.88	0	1.13
8	29.88	3.5	1.2
9	29.87	4.6	1.35
10	29.86	6.9	1.44
11	29.87	12.7	1.58
12	29.86	9.2	1.64
13	29.85	6.9	1.57
14	29.85	9.2	1.59
15	29.85	10.4	1.62
16	29.86	16.1	1.8
17	29.85	12.7	1.92
18	29.85	15	1.85
19	29.84	8.1	1.57
20	29.84	4.6	1.31
21	29.86	4.6	1.21
22	29.87	5.8	1.16
23	29.86	4.6	1.1
0	29.86	8.1	0.96
1	29.86	5.8	0.99
2	29.85	9.2	0.85
3	29.84	3.5	0.68
4	29.84	4.6	0.62
5	29.84	3.5	0.66
6	29.85	4.6	0.88
7	29.86	5.8	1.16
8	29.86	6.9	1.32
9	29.86	5.8	1.33
10	29.85	9.2	1.44
11	29.85	10.4	1.6
12	29.84	11.5	1.67
13	29.83	8.1	1.68
14	29.83	9.2	1.7
15	29.83	16.1	1.79
16	29.84	16.1	1.87
17	29.84	11.5	1.9
18	29.84	15	2.03
19	29.86	9.2	1.87
20	29.86	6.9	1.53
21	29.88	6.9	1.47
22	29.9	5.8	1.26
23	29.91	4.6	1.12
0	29.91	0	0.99