Question

need helping find the P-value for part C

Topic: Wx Accesst x Excel Or X0 xBook 5 MindTap x 6637 B x C Sign In xMicroso x xBook 1.x x Mail - D x | Floridax M Your qu + X C about:blank Apps Log In-WordPre. C My Courses The.. we MyUCF MindTap-QMB2 GEB3375 Excel Online X template Saved File Review View Tell me what you want to do Home Insert Data SUMMARY OUTPUT K45 A P G H T Price ($1000) 1650.0 1 Year Model Rating 18 Part a Use t Make Chevrolet Corvette 1984 Chevrolet Corvette 265/225-hp Chevrolet Corvette coupe (340-bhp 4-speed) Chevrolet Corvette coupe Silver Anniversary 1956 19 4100.0 4 1963 18 1100.0 1978 19 1400.0 1960-1963 1962-1964 Ferrari 250 GTE 2+2 16 360.0 7 Ferrari 250 GTL Lusso 19 2500,0 1962 Ferrari 250 GTO 18 425.0 275 GTB/4 NART Spyder 365 GTB/4 Daytona 1967-1968 Ferrari 17 430.0 10 1968-1973 1962-1967 160.0 Ferrari 17 11 12 75.0 Jaguar E-type OTS Jaguar E-type Series ll OTS Jaguar E-type Series lll OTS Jaguar XK 120 roadster (steel) Jaguar XK C-type Jaguar XKSS 15 1969-1971 14 60.0 13 1971-1974 16 140.0 14 1951-1954 17 360.0 15 1950-1953 230.0 16 16 1956-1957 13 70.0 17 18 Rating2 log(Price) Formula 3.22 =A20^2 19 Price ($1000) Rating log(Rating) 20 18 324 1.26 1650.0 ELOG(A20) LOG(D20) =LOG(A21) LOG(D21) 21 19 361 1.28 4100.0 3.61 A21 2 0ni 4400 0n OO/AOOV LOOIDO DFlorida Co x Topic: We X Access to 6637 Bou x Microsoft Book 1.xls x C Sign In or x Mail Dar x + MindTap M Your ques X C https://ng.cengage.com/static/nb/ui/evo/index. html?deploymentid=57360043871 15514484747064 &elSBN=97813371 153778&snapshotid=1160247&id =47600 6302& Apps Log In-WordPre. C My Courses The.. we MGEB3375 MindTap-QMB2 MyUCF CENGAGE MINDTAP Q Search this course Microsoft Excel: Structured Activity Section 16.1: General Linear Model Question 1 92.86/100 -1500 Ratine to be anprocrinte. A simple ineer regression model does not apper vo independent varisbles. b. Develop an estimated multiple regression equation with rarity rating and as the Price 34045 404 Rating+155 Rating to whole numbers) between 0 and 1. What is the valkue of the coefficient of determinetion? Mate: recort (to 3 decimals) 710 What is the value of the F test ptotistic? (to 2 decimals) 14.71 What is the -value? (to 4 decimals) co0 e nonlinear relationship shown by equation Efy)-BaUse logarithms to develop an estimated regression equation for this model. Considen log(Price)10.353 10.593C log(Rating) (to 3 decimals) What is the value of the coofficient of determination? Mote: report R between o and 1. A-Z (to 3 decimals) 8 What is the value of the P test statistic? (to 2 decimals) 61 6 What is the p value? 6.1214 (to 4 decimals) e estimated regression cquation developed in part (b) or part (c)? Explain. d. Do you prefor The model in nertG) s preferred because it provides a better fit Current acom 82.88/100 pts (92 55% Bedk Nart

Answer 1

Price	Rating	log(Price)	log(Rating)	SUMMARY OUTPUT
1650	18	7.408531	2.890371758
4100	19	8.318742	2.944438979	Regression Statistics
1100	18	7.003065	2.890371758	Multiple R	0.893731491
1400	19	7.244228	2.944438979	R Square	0.798755978
360	16	5.886104	2.772588722	Adjusted R Square	0.783275669
2500	19	7.824046	2.944438979	Standard Error	0.623259684
425	18	6.052089	2.890371758	Observations	15
430	17	6.063785	2.833213344
160	17	5.075174	2.833213344	ANOVA
75	15	4.317488	2.708050201		df	SS	MS	F	Significance F
60	14	4.094345	2.63905733	Regression	1	20.04345359	20.04345	51.59819	7.12148E-06
140	16	4.941642	2.772588722	Residual	13	5.049884231	0.388453
360	17	5.886104	2.833213344	Total	14	25.09333782
230	16	5.438079	2.772588722
70	13	4.248495	2.564949357		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
				Intercept	-23.8396464	4.155373901	-5.73706	6.86E-05	-32.81678592	-14.862507
				X Variable 1	10.59330688	1.474736099	7.183188	7.12E-06	7.407333235	13.7792805

p-value=P(F>51.60|F~F-distriburion with df (1,13))=0.000007 approximately 0.0000 (rounded 4 decimal places)