The questions are attached to the the second sheet of the excel file and the first sheet of the excel file contains the data required

1 answer below »
The questions are attached to the the second sheet of the excel file and the first sheet of the excel file contains the data required
Answered Same DayOct 30, 2021

Answer To: The questions are attached to the the second sheet of the excel file and the first sheet of the...

Sudharsan.J answered on Nov 02 2021
157 Votes
Analysis Results
Inference:
Question-1:
    SUMMARY OUTPUT
    
    
    
    
    
    
    
    
    
    
    
    
    Regression Statistics
     
    
    
    
    
    
    Multiple R
    0.58
    
    
    
    
    
    R Sq
uare
    0.33
    
    
    
    
    
    Adjusted R Square
    0.33
    
    
    
    
    
    Standard Error
    75.38
    
    
    
    
    
    Observations
    2089
    
    
    
    
    
    
    
    
    
    
    
    
    ANOVA
    
    
    
    
    
    
     
    df
    SS
    MS
    F
    Significance F
    
    Regression
    6
    5879204
    979867.3
    172.4529
    2.4E-178
    
    Residual
    2082
    11829803
    5681.942
     
     
    
    Total
    2088
    17709006
     
     
     
    
    
    
    
    
    
    
    
     
    Coefficients
    Standard Error
    t Stat
    P-value
    Lower 95%
    Upper 95%
    Intercept
    14.22
    6.99
    2.03
    0.0422
    0.50
    27.93
    Humidity
    2.43
    0.10
    25.27
    0.0000
    2.24
    2.62
    DewPoint
    -2.34
    0.16
    -14.81
    0.0000
    -2.65
    -2.03
    SE
    -10.97
    5.32
    -2.06
    0.0395
    -21.41
    -0.53
    NE
    -29.63
    7.37
    -4.02
    0.0001
    -44.09
    -15.18
    NW
    -53.97
    6.47
    -8.35
    0.0000
    -66.65
    -41.29
    WindSpeed
    -0.14
    0.04
    -3.66
    0.0003
    -0.21
    -0.06
a)
The fitted equation of the best model is:
 Pm2.5= 14.2156+( 2.4289*humidity) –(2.338*dewpoint) –(10.968*se) –(29.635*ne) –(53.968*nw) –(0.136*windspeed)+6.99
b)
Based on the equation model, a one-unit increase in wind on south east will result in -10.97decrease in pm2.5.
c) the estimated difference between expected value of pm2.5 when the wind comes from southeast direction to the case where the wind comes from the northeast direction is -73.41.
here we assumed humidity, dewpoints, se, ne, nw and windspeed are to be same with one unit.
d)
1. x =south east and north east wind, y = Pm2.5
2. null and alternative hypotheses and the level of significance of 1%
Since you are asked
Null hypothesis: The...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here