Take Test: Exam #$2$ Ch$8-13$

Question #$1-$ Chapter $8$

Directions: Use the "Solved Problem $1"$ on page $320$ to assist with answering the following question

Christian offers special pricing for his homemade ice cream during Homecoming, Let $Y$ be the number of ice creams sold, and $x$ be the price. Based on the historical observations and calculations in the following table, use Excel's regression to determine: $($NOTE: Round ALL answers to the second decimal place... Example.... $132\mathrm{.}54)$

A$)$ the value of $a=$

B$)$ the value of $b=$

C$)$ the value of $r^2=$

D$)$ How many ice cream cones can Christian expect to sell at $$4\mathrm{.}00$ each?

E$)$ How many ice cream cones can Christian expect to sell at $$3\mathrm{.}50$ each?

F$)$ Based on $r^2,$ is the equation a good fit for predicting sales? $($Type the WORD "yes" or $"$no$"$ ONLY$)$