Sorry for the inconvenient.
access the data sets on triolastats.com on the excel part
Name_ BUS12305 EXCEL Assignment 3 - Regression Directions: Perform an entire regression analysis, on each of the 3 cases, using Excel. Provide your boss with the Excel Regression Analysis, graph, and the following information (typed). Turn in 3 pages of information for the different cases and your name as a header. Round your answers to 3 decimal places. Note: You can copy and paste Excel data/tables into Word so that you can also type. Refer to Data Set 1: Body. You will examine Systolic (y) and Age (x). 1. Graph the scatter plot with the regression trend line on it. Line Fit Plots then add the trend line on the graph b. Make graph bigger so we can see what is going on C . Relabel the legend, title, horizontal, and vertical axis 2 . Correlation Coefficient Mul. R Coefficient of determination. 4. Regression equation .lbx + 103.y Interpret the slope of the regression equation with respect to data. Use the regression equation to predict the systolic blood pressure of someone who is 100 years old. At a significance level of 0.05, what is the best prediction for the systolic blood pressure of someone who is 21 years old? 8. How much variation in the systolic blood pressure can be explained in the variation in the age? Refer to Data Set 20: Car Measurements. You will examine Highway (y) and Weight (x). 1. Graph the scatter plot with the regression trend line on it. a. Line Fit Plots then add the trend line on the graph b. Make graph bigger so we can see what is going on c. Relabel the legend, title, horizontal, and vertical axis 2 . Correlation Coefficient Coefficient of determination 4. Regression equation Interpret the slope of the regression equation with respect to data. Use the regression equation to predict the highway gas mileage for a car that weighs 5000 lbs. 7 . At a significance level of 0.01, what is the best prediction for the highway gas mileage of a car that weighs 2995 lbs . ? 8 . How much variation in the highway gas mileage cannot be explained by the variation in the weight of the car? Refer to Data Set 4: Births. You will examine Length of Stay (y) and Birth Weight (x). 1. Graph the scatter plot with the regression trend line on it. a. Line Fit Plots then add the trend line on the graph b. Make graph bigger so we can see what is going on c. Relabel the legend, title, horizontal, and vertical axis IN Correlation Coefficient Coefficient of determination 4. Regression equation . Interpret the slope of the regression equation with respect to data. 6. Use the regression equation to predict the length of the hospital stay for a baby that weighs 4,545 grams and explain your results and what they mean in the real world. 7. At a significance level of 0.01, what is the best prediction for the length of the hospital stay for a baby that weighs 1000g? . How much variation in the length of the hospital stay can be explained by the variation in the birth weight of the
