i want the anwer of 11.21

but i need all the answer and explanation which is done on excel only

cause i have an assg so i need to solve in excel using formula and submitted it

a. Fit a smple linear regression model relating number (y) of solf ware millionaire berthdsys in a decade to lotal number (x) of US births Give the least squares prediction equation. b. Practically inferpret the estimated y-intercept and stope of the model, part a. c. Predict the number of sofware inittionalie birthday that will occur in a decade where the total number of US. births is 35 million. d. Fit a sinple linear regression model relating number () of software miltionaire birthdays in a deca de to number (x) of CEO birthdays Give the least squares prediction equation: e. Practicilly interpret the estimat:dy-intercept and stope of the model, part d. c. Predict the number of software millionaire birthdays that will occur in a decade where the number of CEO birthdays (from a random sample of 70 companies) is 10 Applying the Concepts-Intermediate 11.20 Public corruption and bad weather. The Federal Emergency Management Agency (FEMA) provides disaster relief for states impacted by natural disasters (e e, hurricanes, tornados Doods). Do these bad weather windfalls lead to public corruption? This was the research question of interest in an article publisbed in the fournal of Law and Economics (Nov, 2008). Data on y= average annual number of public corruption convictions (pet 100,000 residents) and x= average annual FEMA relief (in dollars) per capita for each of the 50 states were used in the investigation. a. Access the data, saved in the file, and construct a scat. terplot. Do you observe a trend? b. Fit the simple linear regression model, E(y)=0+1x, to the data and obtain estimates of the y-intercept and slope. c. Practically interpret the estimated y-intercept and esti. mated slope. 11.21 Ranking driving performance of professional golfers. Refer to The Sporr Joumal (Winter 2007) study of a new method for ranking the total driving performance of golfers on the Professional Golf Asscciation (PGA) tour, Exercise 250 (p. 72). Recall that the method computes a driving performance index based on a golfer's average driving distance (yards) and driving accuracy (percent of drives that land in the fairway). Data for the top 40 PGA golfers (as ranked by the new method) are saved in the file. (The first five and last five observationt act Ly, the table). the table) poor (Tible 2l. a. Write the equation of a straight-lane model relatay h ing accurocy (y) to driving distance (x). b. Fit the model, part a, to the data usiof iest linear regression. Give the least squares prebies equation. c. Interpret the estimated y-intercept of the line d. Interpret the estimated slope of the line. e. In Exercse 2.132 (p. 106), you were informed ta professional golfer, practicing a new swing to ascar his average driving distance, is concerned that tis th. ing accuracy will be lower. Which of the two etanals y-intercept or slope, will help you deterinine it golfer's concern is a valid one? Explain 11.22 Sweetness of orange juice. The quality of the and juice produced by a manufactorer (eg. Mante Ne Tropicana) is co vtantly monitorcd. There are the best-tasting orange juice. For example, one eats turer has developed a quantitative index of the "quet ness" of orange juice. (The higher the index, ter ofet the juice.) Is there a relationship between the rasp? index and a chemical measure such as the ameat de tersoluble pectin (parts per milition) in the orast Data collected on these two variables for 24 pro runs at a juice manufacturing plant are shown in on the next page. Suppose a manulacturet simple linear regression to predict the swecteca 0 ) the amount of pectin (x) a. Fit a smple linear regression model relating number (y) of solf ware millionaire berthdsys in a decade to lotal number (x) of US births Give the least squares prediction equation. b. Practically inferpret the estimated y-intercept and stope of the model, part a. c. Predict the number of sofware inittionalie birthday that will occur in a decade where the total number of US. births is 35 million. d. Fit a sinple linear regression model relating number () of software miltionaire birthdays in a deca de to number (x) of CEO birthdays Give the least squares prediction equation: e. Practicilly interpret the estimat:dy-intercept and stope of the model, part d. c. Predict the number of software millionaire birthdays that will occur in a decade where the number of CEO birthdays (from a random sample of 70 companies) is 10 Applying the Concepts-Intermediate 11.20 Public corruption and bad weather. The Federal Emergency Management Agency (FEMA) provides disaster relief for states impacted by natural disasters (e e, hurricanes, tornados Doods). Do these bad weather windfalls lead to public corruption? This was the research question of interest in an article publisbed in the fournal of Law and Economics (Nov, 2008). Data on y= average annual number of public corruption convictions (pet 100,000 residents) and x= average annual FEMA relief (in dollars) per capita for each of the 50 states were used in the investigation. a. Access the data, saved in the file, and construct a scat. terplot. Do you observe a trend? b. Fit the simple linear regression model, E(y)=0+1x, to the data and obtain estimates of the y-intercept and slope. c. Practically interpret the estimated y-intercept and esti. mated slope. 11.21 Ranking driving performance of professional golfers. Refer to The Sporr Joumal (Winter 2007) study of a new method for ranking the total driving performance of golfers on the Professional Golf Asscciation (PGA) tour, Exercise 250 (p. 72). Recall that the method computes a driving performance index based on a golfer's average driving distance (yards) and driving accuracy (percent of drives that land in the fairway). Data for the top 40 PGA golfers (as ranked by the new method) are saved in the file. (The first five and last five observationt act Ly, the table). the table) poor (Tible 2l. a. Write the equation of a straight-lane model relatay h ing accurocy (y) to driving distance (x). b. Fit the model, part a, to the data usiof iest linear regression. Give the least squares prebies equation. c. Interpret the estimated y-intercept of the line d. Interpret the estimated slope of the line. e. In Exercse 2.132 (p. 106), you were informed ta professional golfer, practicing a new swing to ascar his average driving distance, is concerned that tis th. ing accuracy will be lower. Which of the two etanals y-intercept or slope, will help you deterinine it golfer's concern is a valid one? Explain 11.22 Sweetness of orange juice. The quality of the and juice produced by a manufactorer (eg. Mante Ne Tropicana) is co vtantly monitorcd. There are the best-tasting orange juice. For example, one eats turer has developed a quantitative index of the "quet ness" of orange juice. (The higher the index, ter ofet the juice.) Is there a relationship between the rasp? index and a chemical measure such as the ameat de tersoluble pectin (parts per milition) in the orast Data collected on these two variables for 24 pro runs at a juice manufacturing plant are shown in on the next page. Suppose a manulacturet simple linear regression to predict the swecteca 0 ) the amount of pectin (x)