Regression and Correlation Responses

profileislandbuilt
Forum7.xlsx
Home>Mathematics homework help>Statistics homework help>Regression and Correlation Responses

Sheet1

Type Year Make Model Price MPG(CITY) MPG (HIGHWAY) Weight
variable type: qualitative variable type: quantitative variable type: qualitative variable type: qualitative variable type: quantitative variable type: quantitative variable type: quantitative variable type: quantitative
SUV 2021 Mazda CX-30 $22,795 25 33 3232 lbs.
compact crossover 2021 Toyota rav4prime $29,458 36 40 5,530 lbs
SUV 2021 Chrysler Voyager $28,730 19 28 4,330 lbs.
minivan 2020 kia Sedona $28,720 18 24 6,085 lbs
minivan 2020 Dodge grand caravan $29,025 17 25 4510 lbs
passenger wagon 2020 Ford transit connect $28,315 24 26 3689 lbs.
SUV 2020 Volkswagen Tigwan $25,965 22 29 3847 lbs.
SUV 2019 kia Sorento $28,110 22 29 3810 lbs.
SUV 2020 Honda Odyssey $32,110 19 28 4593 lbs.
SUV 2021 Hyundai Palisade $33,665 19 24 4,284 lbs.
correlation
correlation 0.9129329507
R squared 83%
regression
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9129329507
R Square 0.8334465725
Adjusted R Square 0.8126273941
Standard Error 2.1028536562
Observations 10
ANOVA
df SS MS F Significance F
Regression 1 177.0240520043 177.0240520043 40.0326350606 0.0002260893
Residual 8 35.3759479957 4.4219934995
Total 9 212.4
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 10.9295774648 2.8708764421 3.8070525448 0.0051843362 4.3093245176 17.549830412 4.3093245176 17.549830412
X Variable 1 0.7995666306 0.1263710436 6.3271348224 0.0002260893 0.5081544814 1.0909787797 0.5081544814 1.0909787797