0% found this document useful (0 votes)
29 views14 pages

Regression Analysis Summary

1. Ten data points measuring time, population, and PM2.5 levels were collected in the morning and afternoon. Regression analyses found weak or no correlations between the variables. 2. Predicted PM2.5 levels were calculated based on time and %RH inputs, but results varied widely with R-squared values close to 0, indicating poor prediction capability from the models. 3. Basic statistical analyses identified potential outliers in the minimum and maximum PM2.5 data, but the small sample size limited further conclusions about patterns in the air quality data.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
29 views14 pages

Regression Analysis Summary

1. Ten data points measuring time, population, and PM2.5 levels were collected in the morning and afternoon. Regression analyses found weak or no correlations between the variables. 2. Predicted PM2.5 levels were calculated based on time and %RH inputs, but results varied widely with R-squared values close to 0, indicating poor prediction capability from the models. 3. Basic statistical analyses identified potential outliers in the minimum and maximum PM2.5 data, but the small sample size limited further conclusions about patterns in the air quality data.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 14

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.004031
R Square 1.625E-05
Adjusted R-0.124982
Standard E 2.42124
Observatio 10

ANOVA
df SS MS F Significance F
Regression 1 0.000762 0.000762 0.00013 0.991182
Residual 8 46.89924 5.862405
Total 9 46.9

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 32.44454 30.22865 1.073304 0.31444 -37.26285 102.1519 -37.26285 102.1519
Time (Morn-1.219306 106.9434 -0.011401 0.991182 -247.8313 245.3927 -247.8313 245.3927
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.093977
R Square 0.008832
Adjusted R-0.274359
Standard E 23.00279
Observatio 10

ANOVA
df SS MS F Significance F
Regression 2 33.00297 16.50148 0.031186 0.969429
Residual 7 3703.897 529.1281
Total 9 3736.9

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -3635.787 33580.48 -0.108271 0.916819 -83041 75769.42 -83041 75769.42
Predicted 114.8362 1043.363 0.110064 0.915448 -2352.324 2581.997 -2352.324 2581.997
%RH (Morn-0.198281 1.757759 -0.112803 0.913353 -4.354722 3.95816 -4.354722 3.95816
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.107301
R Square 0.011514
Adjusted R-0.270911
Standard E 33.57757
Observatio 10

ANOVA
df SS MS F Significance F
Regression 2 91.92576 45.96288 0.040767 0.960279
Residual 7 7892.174 1127.453
Total 9 7984.1

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -13350.24 49018.02 -0.272354 0.793209 -129259 102558.9 -129259 102558.9
Predicted 417.0739 1523.015 0.273848 0.792106 -3184.284 4018.432 -3184.284 4018.432
%RH (Morn0.257128 2.565833 0.100212 0.922986 -5.810103 6.324358 -5.810103 6.324358
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.111095
R Square 0.012342
Adjusted R-0.111115
Standard E 2.279814
Observatio 10

ANOVA
df SS MS F Significance F
Regression 1 0.519598 0.519598 0.09997 0.759958
Residual 8 41.5804 5.19755
Total 9 42.1

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 33.61792 4.230148 7.94722 4.58E-05 23.86318 43.37266 23.86318 43.37266
Time (Afte -9.910214 31.34358 -0.31618 0.759958 -82.18864 62.36822 -82.18864 62.36822
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.663743
R Square 0.440555
Adjusted R 0.280714
Standard E 8.330853
Observatio 10

ANOVA
df SS MS F Significance F
Regression 2 382.5783 191.2891 2.756204 0.130963
Residual 7 485.8217 69.40311
Total 9 868.4

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -142.6932 105.0615 -1.358187 0.216552 -391.1242 105.7378 -391.1242 105.7378
Time (Afte 257.5407 123.9569 2.077663 0.076348 -35.57083 550.6522 -35.57083 550.6522
%RH (After-0.147496 0.683317 -0.215853 0.835258 -1.763283 1.468292 -1.763283 1.468292
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.560804
R Square 0.314501
Adjusted R 0.118644
Standard E 14.08035
Observatio 10

ANOVA
df SS MS F Significance F
Regression 2 636.7066 318.3533 1.605767 0.266701
Residual 7 1387.793 198.2562
Total 9 2024.5

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 171.0225 177.5692 0.963132 0.367565 -248.8619 590.9069 -248.8619 590.9069
Time (Afte -19.34737 209.5051 -0.092348 0.929009 -514.7483 476.0535 -514.7483 476.0535
%RH (After-1.950607 1.154904 -1.688978 0.135075 -4.681522 0.780307 -4.681522 0.780307
Time (Morning) Population (Morning)
6:42 33
6:40 36
7:00 32
6:40 29
6:40 31
6:29 32
6:48 35
7:05 33
6:55 31
6:50 29

Coefficients (Time vs. Pop.)


Time y-int
-1.21930567315839 32.4445385266723

Coefficients (PM2.5min vs. %RH, Predicted Pop.)


Predicted Pop. %RH
114.836241335881 -0.198281128452246
Coefficients (PM2.5min vs. %RH, Predicted Pop.)
Predicted Pop. %RH
417.073892577322 0.25712753754309

Enter time to determine PM2.5: Enter %RH to determine PM2.5:


6:40 87

Predicted PM2.5min Predicted PM2.5max


33.8769475196946 62.63670324743
PM2.5min (Morning) Predicted Pop. (Morning)
19 32.1041490262489
19 32.1058425063505
9 32.0889077053345
60 32.1058425063505
54 32.1058425063505
41 32.1151566469094
10 32.0990685859441
52 32.0846740050804
55 32.0931414055885
20 32.0973751058425

y-int
-3635.78687265603

y-int
-13350.2421011169

Average PM2.5
48.2568253835623
%RH (Morning) PM2.5max (Morning)
75 33
83 80
92 16
77 78
87 85
82 61
85 28
91 83
82 99
81 30
Predicted PM2.5min (Morning) Predicted PM2.5max (Morning)
36.061848171476 58.8448664589323
34.6700720335039 61.6081930972578
30.9408129809754 56.8592775553443
35.8597588042171 60.0654278719976
33.8769475196946 62.63670324743
35.9379540550085 65.2357504186075
33.4956182180163 59.2972228204253
30.6529118853127 54.8363841728497
33.409806489612 56.0537680248635
34.0942698421795 57.5624063322739
Time (Afternoon)
15:29
14:49
14:46
14:48
15:02
16:41
15:18
15:17
14:47
14:58

Coefficients (Time and RH VS PM2.5min)


Time
257.540666867077
Coefficients (Time and RH VS PM2.5max)
Time
-19.3473652682936

Enter time to determine PM2.5:


15:29

Predicted PM2.5min
13.87

OUTLIER TEST in minimum PM


Quartile 1
Quartile 2
Interquantile range (IQR)
Upper bound
Lower bound

OUTLIER TEST in maximum PM


Quartile 1
Quartile 2
Interquantile range (IQR)
Upper bound
Lower bound
%RH (Afternoon) PM2.5min (Afternoon)
65 29
61 0
66 9
71 8
69 11
61 26
70 1
71 3
65 6
74 11

%RH y-int
-0.147495682401357 -142.693205747542

%RH y-int
-1.95060741968334 171.022492846112

Enter %RH to determine PM2.5:


65

Predicted PM2.5max Average PM2.5


44.23 29.0510425646972

3
11
8
23
15

19
42
23
76.5
53.5
PM2.5max (Afternoon) Time (Afternoon)
42 15:29
21 14:49
40 14:46
19 14:48
30 15:02
42 16:41
4 15:18
7 15:17
46 14:47
24 14:58
%RH (Afternoon)
65
61
66
71
69
61
70
71
65
74

You might also like