(1) On the Bikes worksheet, create a regression to try and predict Price with Weight and Type (use dummy variables). (To two decimal places) The estimated y-hat equation for a Road bike has an intercept of ________ and slope of ________.

(2) On the Bikes worksheet, compute a Partial F Test to test the "Type" dummy variables. (To two decimal places) The Partial F Stat is ________.

(3) On the Bikes worksheet, compute a Partial F Test to test the "Type" dummy variables. (To three decimal places) The p-value for the Partial F Test is _______.

\begin{tabular}{|r|l|l|r|r|} \hline 1 & Brand and Model & Type & Weight & Price \\ \hline 2 & Klein Rve v & Road & 20 & 1800 \\ \hline 3 & Giant OCR Composite 3 & Road & 22 & 1800 \\ \hline 4 & Giant OCR 1 & Road & 22 & 1000 \\ \hline 5 & Trek Pilot 2.1 & Road & 21 & 1320 \\ \hline 6 & Cannondale Synapse 4 & Road & 21 & 1050 \\ \hline 7 & LeMond Poprad & Road & 22 & 1350 \\ \hline 8 & Raleigh Cadent 1.0 & Road & 24 & 650 \\ \hline 9 & Giant FCR3 & Fitness & 23 & 630 \\ \hline 10 & Schwinn Super Sport GS & Fitness & 23 & 700 \\ \hline 11 & Jamis Coda Comp & Fitness & 26 & 830 \\ \hline 12 & Cannondale Road Warrior 400 & Fitness & 25 & 700 \\ \hline 13 & Schwinn Sierra GS & Comfort & 31 & 340 \\ \hline 14 & Mongoose Switchback SX & Comfort & 32 & 280 \\ \hline 15 & Giant Sedona DX & Comfort & 32 & 360 \\ \hline 16 & Diamondback Wildwood Deluxe & Comfort & 34 & 350 \\ \hline 17 & Specialized Crossroads Sport & Comfort & 31 & 330 \\ \hline \end{tabular}