A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 10 students who took thecourse last quarter follow.HoursTotalSpent StudyingPoints Earned45403035907560651059065509090808055457565(a) Develop an estimated regression equation showing how total points earned can be predicted from hours spent studying. (Round your numerical values to two decimal places.) (b) Test the significance of the model with a = 0.05. (Use the Ftest.)State the null and alternative hypotheses.O Ho: P1= 0H B, +oO Hg: B1 0B, z o1.O Ho: Po+0H Po= 0७ H,: B, + 0H B1-0O Ho: Bo = 0H Bo# 0%3DFind the value of the test statistic. (Round your answer to two decimal places.)Find the p-value. (Round your answer to three decimal places.)p-value =ww.State your conclusion.O Do not reject H,. We conclude that the relationship between hours spent studying and total points earned is significant.Reject H. We cannot conclude that the relationship between hours spent studying and total points earned is significant.O Do not reject H,. We cannot conclude that the relationship between hours spent studying and total points earned is significant.O Reject H, We conclude that the relationship between hours spent studying and total points earned is significant.:(c) Predict the total points earned by Mark Sweeney. He spent 85 hours studying. (Round your answer to two decimal places.)points(d) Develop a 95% prediction interval for the total points earned by Mark Sweeney. (Round your answers to two decimal places.)points topoints

Using Excel megastat > regression :

A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 10 students who took the course last quarter follow. Hours Total Spent Studying Points Earned 45 40 30 35 90 75 60 65 105 90 65 50 90 90 80 80 55 45 75 65 (a) Develop an estimated regression equation showing how total points earned can be predicted from hours spent studying. (Round your numerical values to two decimal places.)

A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 10 students who took the course last quarter follow. Hours Total Spent Studying Points Earned 45 40 30 35 90 75 60 65 105 90 65 50 90 90 80 80 55 45 75 65 (a) Develop an estimated regression equation showing how total points earned can be predicted from hours spent studying. (Round your numerical values to two decimal places.)

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter6: Exponential And Logarithmic Functions

Section6.8: Fitting Exponential Models To Data

Problem 3TI: Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to...

See similar textbooks

Similar questions

Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4
What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?
The following fictitious table shows kryptonite price, in dollar per gram, t years after 2006. t= Years since 2006 0 1 2 3 4 5 6 7 8 9 10 K= Price 56 51 50 55 58 52 45 43 44 48 51 Make a quartic model of these data. Round the regression parameters to two decimal places.
If your graphing calculator is capable of computing a least-squares sinusoidal regression model, use it to find a second model for the data. Graph this new equation along with your first model. How do they compare?
Table 2 shows a recent graduate’s credit card balance each month after graduation. a. Use exponential regression to fit a model to these data. b. If spending continues at this rate, what will the graduate’s credit card debt be one year after graduating?
Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to 2012. a. Let x represent time in years starting with x=0 for the year 1997. Let y represent the number of seals in thousands. Use logistic regression to fit a model to these data. b. Use the model to predict the seal population for the year 2020. c. To the nearest whole number, what is the limiting value of this model?
A marketing professor at Givens College is interested in the relationshipbetween hours spent studying and total points earned in a course. Datacollected on 10 students who took the course last quarter follow. Hours Spent Studying Total Points Earned 453090601056590805575 40357565905090804565 a. Develop an estimated regression equation showing how total points earned is related to hours spent studying.b. Test the significance of the model with α= .05.c. Predict the total points earned by Mark Sweeney. He spent 95hours studying.d. Develop a 95% prediction interval for the total points earned byMark Sweeney.
A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 10 students who took the course last quarter follow. HoursSpent Studying TotalPoints Earned 45 40 30 35 90 75 60 65 105 90 65 50 90 90 80 80 55 45 75 65 (a)Develop an estimated regression equation showing how total points earned can be predicted from hours spent studying. (Round your numerical values to two decimal places.) ŷ = (b) Test the significance of the model with ? = 0.05. (Use the F test.) = State the null and alternative hypotheses. H0: ?0 = 0Ha: ?0 ≠ 0 H0: ?1 ≥ 0Ha: ?1 < 0 H0: ?1 = 0Ha: ?1 ≠ 0 H0: ?1 ≠ 0Ha: ?1 = 0 H0: ?0 ≠ 0Ha: ?0 = 0 Find the value of the test statistic. (Round your answer to two decimal places.) = Find the p-value. (Round your answer to three decimal places.) p-value = State your conclusion. (A) Do not reject H0. We conclude that the relationship between…
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenueas a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly GrossRevenue($1000s) Television Advertising($1000s) Newspaper Advertising($1000s) 96 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 95 3.0 3.3 94 3.5 2.3 94 2.5 4.2 94 3.0 2.5 a. Develop an estimated regression equation with the amount of televisionadvertising as the independent variable.b. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables. c. Is the estimated regression equation coefficient for television advertisingexpenditures the same in part (a) and in part (b)? Interpret the coefficient in each case. d. Predict weekly gross revenue for a week when $3500 is spent on television advertising and $1800 is spent on newspaper advertising.
A marketing professor at Givens College is interested in the relationship between hoursspent studying and total points earned in a course. Data collected on 156 students whotook the course last semester are provided in the file MktHrsPts.a. Develop a scatter chart for these data. What does the scatter chart indicate about therelationship between total points earned and hours spent studying?b. Develop an estimated regression equation showing how total points earned is relatedto hours spent studying. What is the estimated regression model?c. Test whether each of the regression parameters b0 and b1 is equal to zero at a 0.01level of significance. What are the correct interpretations of the estimated regressionparameters? Are these interpretations reasonable?d. How much of the variation in the sample values of total point earned does the modelyou estimated in part b explain?e. Mark Sweeney spent 95 hours studying. Use the regression model you estimated inpart b to predict the total points…
If we collect monthly sales over two years for N=100 stores, we should not apply a simple linear regression model directly to the data, because the observations are not independent with each other. Is this statement True or False? A) True B) False
The owner of Showtime Movie Theaters, Inc. would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly GrossRevenue($1000s) TelevisonAdvertising($1000s) NewspaperAdvertising($1000s) 96 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 95 3.0 3.3 94 3.5 2.3 94 2.5 4.2 94 3.0 2.5 Part A: Develop an estimated regression equation with the amount of television advertising as the independent variable. Part B: Develop an estimated regression equation with both television advertising and news paper advertising as independent variables. Part C: Is the estimated regression rquation coefficient for television advertising expenditures the same in part (a) and in part (b) ? Interpret the coefficient in each case. Part D : Predict Weekly gross revenue for a week $3500 is spent on television advertising and $1800 is spent on newspaper advertising? Please hurry