Complete the following analysis using EXCEL and the LINEST function as described in class. More information on this function and regression analysis in general can be found here. The following data represents the measured velocity of a constantly accelerating car as a function of time. time (s) 1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0 9.0 velocity (m/s) 1.5 3.7 4.2 6.7 8.3 9.0 10.6 13.0 13.5 Assume that time is measured with much more accuracy then velocity so that time is the logical choice for the independent variable. Make a scatter plot of the data in Excel and fit the data with a line-of-best-fit. Display the equation on the plot and do not force the y-intercept to be zero. Add axis labels (with units) to your plot, copy it to a Word document, write a descriptive caption, save it as a PDF following the directions found here, and submit it using the show-my-work function below. This portion of the lab is worth 3 points. Using the LINEST function, calculate the slope, y-intercept, and standard error of the slope. Enter this data below. slope = 1.516667 y-intercept = 0.25 ✔ m/s2 ✔ m/s standard error of the slope = 0.063683 m/s2

- X Wins and ERA Earned run Wins, x average, y 20 2.79 18 3.31 17 2.65 16 3.83 14 3.94 12 4.27 11 3.78 9 5.18 Print Done

Given the data points listed below, use linear regression to find the expression y = %3D mx + b. List the slope of the best-fit line in the box below (round to one digit past the decimal point). y 2 2 3 15 5 14 8 55 |13 68 15 121

The table shows the approximate chirping rate at various temperatures for one type of cricket. Use the linear regression feature on a graphing calculator to determine an equation of the line that best fits the data. Round to the hundredths. ⒸEncikAn/Shutterstock.com X Temperature (°F) 50 60 70 80 100 Chirps per Minute 20 80 115 150 250

While collecting data on shoe sizes (y) compared to heights in inches (x) of male students in the class a student found that the shoe sizes ranged from size 7 to size 11 and the heights of the students ranged from 60 to 72 inches. The student ran a linear regression to get the function = 1 -x- 3 13 where y is the shoe size and is the height of the person in inches. What would be the shoe size for a student who was 73 inches tall? Shoe sizes only show up in incriments of 0.5 (ie. 7, 7.5, 8, 8.5, 9, 9.5, ....) so round to the nearest 1/2 shoe size. Show all your work.

We run the following regression using a sample of 148 women living in the western states. The variable wage is the hourly wage ( in USD) and educ is the number of years of education completed.             wage  =  -3.07   +   1.52 educ         Which statement best described the estimated slope coefficient? Group of answer choices A 1.52 extra years of education is predicted to increase wage by 1 USD An extra year of education is predicted to increase hourly wage by 1.52 USD A 1 percent increase in education is predicted to increase wage by 1.52 percent A 1.52 percent increase in education is predicted to increase wage by 1

Perform a linear regression analysis on the following data and determine the "a" coefficient (i.e., slope): Y 4.99 22.19 1.96 9.89 2.98 11 9 40.46 4.04 18.93 6.06 25 0.88 0.19 8.02 34.02 6.97 28.03

Use Excel to Run the Regressions:1. Wage and Age: Do you think a worker’s wage is related to his/her age? It is expected that wagesincrease with age up to certain age, after that wages go down. The “Wage Quadratic Data” fileposted contains data on the hourly wage (in $) for construction workers, workers’ ageand whether the worker has a bachelor’s degree or not (Graduate equals 1 if the worker has abachelor’s degree and 0 otherwise). Use the data file to answer the following questions:A) Build a model to predict the hourly wage of construction workers based on their education andage.B) Use the model to predict the hourly wage for a college graduate construction worker if his/herage is 30, 50, and 70c) Based on your model, calculate the age at which the hourly wage for construction workers ismaximized.

Find the intercept (b0) for the regression equation for the following values. Round to 3 decimal places.  Intercept xi yi 33 180 25 170 50 200 65 172 57 160 27 165