The table below contains the average public school classroom teacher's salaries, yy, for an 11-year period. If xx represents the number of years since 1990, use Excel to find a linear model for the data.   Year 1990 1991 1992 1993 1994 1995 Salary 33855 35031 34984 34221 35488 37443   Year 1996 1997 1998 1999 2000 Salary 37188 40370 40627 41311 43954 With the salary given by y=mx+b m=? b=?

Below is data collected over 6 specific years. The data collected is the Consumer Price Index (CPI) and the cost of a slice of tuna. We would like to build a model using the CPI to predict the cost of a slice of pizza in a given year. Year   1960 1973 1986 1995 2002 2003 CPI (x)   30.2 48.3 112.3 162.2 191.9 197.8 Cost of a slice of tuna(y) 0.15 0.35 1.00 1.25 1.75 2.00   Plot the data. Are we justified in creating a Linear Regression model to predict the price of a pizza slice using the CPI? Why or why not? Calculate the descriptive statistics. Calculate the sums of squares Calculate the slope, intercept, and correlation. What is this correlation value telling us? Assemble the prediction equation, and interpret the slope within the context of the problem. State the hypotheses for the hypothesis test for regression.

The number of Master’s degrees granted at a particular university is given for selected years in the table below.   Year 2005 2010 2015 2020 Number of Master’s Degrees 58 69 76 83   Use the linear regression equation for this data to predict the number of Master’s degrees that this university will grant in the year 2021.    Blank 1. Calculate the answer by read surrounding text.  Round to the nearest whole number of Master's degrees.

Eloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's been tracking her page count at the end of each business day to see if she's on track. Use Excel to fit a trendline to Eloise's data to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next Friday? Assume she works only on weekdays. Day Pages Monday 425 Tuesday 431 Wednesday 449 Thursday 464 Friday 471 A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line? The slope is The intercept is B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday? Yes