Question

In: Statistics and Probability

2. Let x be the number of years after 2007 and y represent the number of...

2. Let x be the number of years after 2007 and y represent the number of students enrolled at WWCC. Answer the following given the data that enrollment was 2055 in the year 2007, 2244 in 2008, 2512 in 2009, 2715 in 2010, and 2765 in 2011.

(a) Find the least-squares line for the data using Excel and submit your file in Canvas.

(b) Using partial derivatives, verify the formula you obtained in Excel.

(c) Find the least-squares error E

Solutions

Expert Solution

(a)

Least square Line: Yt=2080+189.1*t


Related Solutions

Let x be the number of years after 2007 and y represent the number of students...
Let x be the number of years after 2007 and y represent the number of students enrolled at WWCC. Answer the following given the data that enrollment was 2055 in the year 2007, 2244 in 2008, 2512 in 2009, and 2715 in 2010. (a) Find the least-squares line for the data using Excel and submit your file in Canvas. (b) Using partial derivatives, verify the formula you obtained in Excel. (c) Find the least-squares error E.
Let X be the number of heads and let Y be the number of tails in...
Let X be the number of heads and let Y be the number of tails in 6 flips of a fair coin. Show that E(X · Y ) 6= E(X)E(Y ).
2 dice are rolled. Let X be the number on the first die, Y - on...
2 dice are rolled. Let X be the number on the first die, Y - on the second, and Z=X - Y. Find the expectation and standard deviation of Z.
Let the following ODE be given. Let x be a real number. xy"+(1-x)y' = (k-1/2)y Give...
Let the following ODE be given. Let x be a real number. xy"+(1-x)y' = (k-1/2)y Give an explict solution for k=-2.5
Let x be the number of different research programs, and let y be the mean number...
Let x be the number of different research programs, and let y be the mean number of patents per program. As in any business, a company can spread itself too thin. For example, too many research programs might lead to a decline in overall research productivity. The following data are for a collection of pharmaceutical companies and their research programs. x 10 12 14 16 18 20 y 1.9 1.4 1.6 1.4 1.0 0.7 Complete parts (a) through (e), given...
Let x and y be integers. Prove that if x^2 + y^2 is a multiple of...
Let x and y be integers. Prove that if x^2 + y^2 is a multiple of 7, then x and y are both multiples of 7.
Let X be the event that the first number is even. Let Y be the event...
Let X be the event that the first number is even. Let Y be the event that the second number is even. Let Z be the event that the sum of the two numbers is even. Are the events X and Z independent? ( Are the events X ∩ Y and Z independent?
2. Let Y = X^2+ X+1. (a) Evaluate the mean and variance of Y, if X...
2. Let Y = X^2+ X+1. (a) Evaluate the mean and variance of Y, if X is an exponential random variable. (b) Evaluate the mean and variance of Y, if X is a Gaussian random variable
Let f ( x , y ) = x^ 2 + y ^3 + sin ⁡...
Let f ( x , y ) = x^ 2 + y ^3 + sin ⁡ ( x ^2 + y ^3 ). Determine the line integral of f ( x , y ) with respect to arc length over the unit circle centered at the origin (0, 0).
Formulate the situation as a system of inequalities. (Let x represent the number of goats the...
Formulate the situation as a system of inequalities. (Let x represent the number of goats the farmer can raise and y represent the number of llamas.) A rancher raises goats and llamas on his 800-acre ranch. Each goat needs 4 acres of land and requires $70 of veterinary care per year, while each llama needs 10 acres of land and requires $56 of veterinary care per year. If the rancher can afford no more than $9,240 for veterinary care this...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT