YieldFetilizerWater201100100032520010001243001000129400100034450010001931002000369200200021030020003064002000297500200033910030003342003000273300300034740030003315003000221100400039620040003043004000381400400031650040002861005000293200500035530050004414005000321500500037710060003922006000361300600043240060004645006000above is the excel data. please solve the excel part with formulas and explanation, thanks The agronomist believed that the amount of rainfall as well as the amount of fertilizer used wouldaffect the crop yield. She did the experiment in the following way. Thirty greenhouses were rented.In each, the amount of fertilizer and the amount of water were varied. At the end of the growingseason, the amount of corn was recorded. Use a = 0.05a) Determine the sample regression line and interpret the coefficients.b) Do these data allow us to infer that there is a linear relationship between the amount of fertilizerand the crop yield?c) Do these data allow us to infer that there is a linear relationship between the amount of water andthe crop yield?d) What can you say about the fit of the multiple regression model?e) Is it reasonable to believe that the error variable is normally distributed with constant variance(Support your answer)?

Disclaimer : “Since you have posted a question with multiple sub-parts, we will solve first three…

Yield Fetilizer Water 201 100 1000 325 200 1000 124 300 1000 129 400 1000 344 500 1000 193 100 2000 369 200 2000 210 300 2000 306 400 2000 297 500 2000 339 100 3000 334 200 3000 273 300 3000 347 400 3000 331 500 3000 221 100 4000 396 200 4000 304 300 4000 381 400 4000 316 500 4000 286 100 5000 293 200 5000 355 300 5000 441 400 5000 321 500 5000 377 100 6000 392 200 6000 361 300 6000 432 400 6000 464 500 6000 above is the excel data. please solve the excel part with formulas and explanation, thank

Yield Fetilizer Water 201 100 1000 325 200 1000 124 300 1000 129 400 1000 344 500 1000 193 100 2000 369 200 2000 210 300 2000 306 400 2000 297 500 2000 339 100 3000 334 200 3000 273 300 3000 347 400 3000 331 500 3000 221 100 4000 396 200 4000 304 300 4000 381 400 4000 316 500 4000 286 100 5000 293 200 5000 355 300 5000 441 400 5000 321 500 5000 377 100 6000 392 200 6000 361 300 6000 432 400 6000 464 500 6000 above is the excel data. please solve the excel part with formulas and explanation, thank

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.6: Regression And Median-fit Lines

Problem 4GP

See similar textbooks

Similar questions

A manufacturing company that produces laminate for countertops is interested in studying the relationship between the number of hours of training that an employee receives and the number of defects per countertop produced. Ten employees are randomly selected. The number of hours of training each employee has received is recorded and the number of defects on the most recent countertop produced is determined. The results are as follows. Hours of Training Defects per Countertop1 54 17 03 32 52 45 15 21 86 2 The estimated regression equation and the standard error are given. Defects per Countertop=6.717822−1.004950(Hours of Training)Se=1.229787 Suppose a new employee has had 1 hour of training. What would be the 90% prediction interval for the number of defects per countertop? Round your answer to two decimal places.
Use the sample data given in tablex 1 2 3 4 5y 3 4 1 2 1a) To Write the regression equation ̂y=mx+bb) Plot the regression equation and the scatter diagram on the same graph
The following table displays the mathematics test scores for a random sample ofcollege students, along with their final SY16C grades.a. Fit the regression line y=a+bx to the data and interpret the results.b. Use the regression equation to determine the SY16C grade for a college student whoscored 60 on their achievement test. What would their SY16C gradebe? Mathematics test(x) SY16C grades(y)1 39 652 43 783 21 524 64 825 57 926 47 897 28 738 75…
In multiple regression, when all independent variables are considered but the order in which they are added to the model is determined by the amount it contributes to the dependent variable, it is called: a.Two step b.Stepwise c.Simultaneous d.Backward step
If we performed a t-test, how many people would be in the study based on the regression model in photo.
A seafood-sales manager collected data on the maximum daily temperature, T, and the daily revenue from salmon sales, R, using sales receipts for 30 days selected at random. Using the data, the manager conducted a regression analysis and found the least-squares regression line to be Rˆ=126+2.37T. A hypothesis test was conducted to investigate whether there is a linear relationship between maximum daily temperature and the daily revenue from salmon sales. The standard error for the slope of the regression line is SEb1=0.65. Assuming the conditions for inference have been met, which of the following is closest to the value of the test statistic for the hypothesis test? t=0.274 A t=0.65 B t=1.54 C t=3.65 D t=193.85 E
The following regression model was estimated. Q is the number of meals served, P is the average price per meal (customer ticket amount, in dollars), Pxis the average price charged by competitors (in dollars), Ad is the local advertising budget for each outlet (in dollars), and I is the average income per household in each outlet’s immediate service area. Least squares estimation of the regression equation on the basis of the 25 data observations resulted in the estimated regression coefficients and other statistics given in Table below. Variable Coefficient Standard Error of Coefficient Intercept Price (P) Competitor Price (Px) Advertising (Ad) Income (I) Coefficient of determination R2 =83.3% 128832.240 –19875.954 15467.936 0.261 8.780 69974.818 4100.856 459.280 0.094 1.017 (a) Interpret the…
The following table displays the mathematics test scores for a random sample of college students, along with their final SY16C grades. a. Fit the regression line y = a+bx to the data and interpret the results. b. Use the regression equation to determine the SY16C grade for a college student who scored60 on their achievement test. What would their SY16C grade be
Suppose a commercial developer in Vereeniging consider to purchase a group of small office buildings in an established business district. He uses multiple linear regression analysis, which was based on a sample of 35 office buildings, to estimate the value of an office building in a given area based on the following variables. Y = Assessed value of the office building (in Rand) X1= Floor space in square meters X2= Number of offices X3= Age of the office building in years Answer the questions that follow by typing only the letter of the correct option (A, B, C, D or E) in the answer spaces provided. Variablesy: Valuex1: Floor Spacex2: Officesx3: Age Model Fitting StatisticsR^2 = 0.9752Adj R^2: ? Regression Coefficients Beta Parameter Standard b Parameter Standard Estimates Error of Beta Estimates Error of b t Statistic Prob > |t|Intcpt…
The St. Lucian Government is interested in predicting the number of weekly riders on the public buses using the following variables: • • • • Price of bus trips per weekThe population in the cityThe monthly income of ridersAverage rate to park your personal vehicle Determine the multiple regression equation for the data. What is the predicted value of the number of weekly riders if: price of bus trips per week = $24; population = $2,000,000; the monthly income of riders = $13,500; and average rate to park your personal vehicle = $150. Interpret the coefficient of determination.
Suppose Tatiyana is interested in the relationship between language ability and time spent reading. She randomly selects a sample of 30 students from the local high school and collects their scores from a language aptitude test. She surveys the sample asking each student how many hours per month he or she spends reading. Using the sample data, Tatiyana produces a scatterplot with reading time on the horizontal axis and language test scores on the vertical axis. She develops a least squares regression equation where ? is the amount of time spent reading during the month and ?̂ is the predicted value of the language test score. ?̂=3.251x+31.237 Compute the value of ?̂ when a student spends 42 hours reading. Give your answer precise to one decimal place. Avoid rounding until the last step. ?̂= ? points Identify all of the true statements regarding the interpretation of ?̂ when ?=42. The value of ?̂ is ? a. the predicted number of students that read for 42 hours. b. the language test…
A regression between foot length(response variable in cm) and height (eexplanatory variable in inches) for 33 students resulted in the following regression equation: y^=10,9+0,23X one student in the sample was 73 inches tall with a foot length of 29cm.What is the predicted foot length for A)33cm B)17,57cm C)27,69cm D)29cm

SEE MORE QUESTIONS

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

Yield	Fetilizer	Water
201	100	1000
325	200	1000
124	300	1000
129	400	1000
344	500	1000
193	100	2000
369	200	2000
210	300	2000
306	400	2000
297	500	2000
339	100	3000
334	200	3000
273	300	3000
347	400	3000
331	500	3000
221	100	4000
396	200	4000
304	300	4000
381	400	4000
316	500	4000
286	100	5000
293	200	5000
355	300	5000
441	400	5000
321	500	5000
377	100	6000
392	200	6000
361	300	6000
432	400	6000
464	500	6000