Question

Question # 3. The following data set records the cost of advertising (in thousands of dollars)...


Question # 3. The following data set records the cost of advertising (in thousands of dollars) and the number of prescriptions written for a new drug (in thousands).



Cost (x)

9

2

3

4

2

6

9

10

Number of

prescriptions (y)

85

61

64

67

60

75

83

87


Using the above data: (Please use Minitab for parts a, b, d)

a) A bivariate (scatter) plot for the data set. (5 points)

b) Find the correlation (r) and its associated p-value. (5 points)

c) Is there a significant relationship between the number of prescriptions written and the cost of advertising? Why or why not? (5 points)

d) Find the regression equation predicting the number of prescriptions based on cost, its associate p-value, and the coefficient of determination (R-Square). (5 points)

e) Should the regression equation be used to make predictions for the number of prescriptions written based on the cost of advertising? Why or why not? (5

points)



f) What is the best prediction for the number of prescriptions written based on advertising costs of $8000? What did you use to make your prediction? (5 points)


0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
Question # 3. The following data set records the cost of advertising (in thousands of dollars)...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The following data gives the monthly sales (in thousands of dollars) for different advertising expenditures (also...

    The following data gives the monthly sales (in thousands of dollars) for different advertising expenditures (also in thousands of dollars) and sales commission percentages. Help me solve this R code, thanks Questions should be answered using the Answer Sheet Template with your name at the top. All relevant R codes, numeric answers and conclusions should be provided. No screenshots are required. Note, only R should be used to answer the questions, as needed. Answers should be written in the appropriate...

  • II 1. The Advertising data set consists of the sales (in thousands of units) of a...

    II 1. The Advertising data set consists of the sales (in thousands of units) of a particular product in 400 different markets. It also contains the advertising budgets (in thousands of dollars) for the product in each of the markets for three different media: TV, radio, and newspaper. The data set is divided in two parts-a training set consisting of 200 observations and a test set consisting of the remaining 200 observations. Three models are used on training data and...

  • Data on advertising expenditures and revenue (in thousands of dollars) for the Restaurant follow. Advertising Expenditures...

    Data on advertising expenditures and revenue (in thousands of dollars) for the Restaurant follow. Advertising Expenditures Revenue 1 20 2 33 4 45 6 40 10 53 14 54 20 55 Let x equal advertising expenditures and y equal revenue. Complete the estimated regression equation below. y = 1.47 + 30.87 Test whether revenue and advertising expenditures are related at a .05 level of significance. SSE = SST = SSR = MSR = MSE= F test statistic = P-value =

  • The paired data below consist of the costs of advertising (in thousands of dollars) and the...

    The paired data below consist of the costs of advertising (in thousands of dollars) and the number of products sold (in thousands): Cost 9 4 2 3 Number 85 68 53 55 Find the value of the linear correlation coefficient r. O 0.9703 O 0.708 O 0.235 O 0.246

  • Help is needed on question 1. The second picture is the data set “Showtime.xlsx” needed to...

    Help is needed on question 1. The second picture is the data set “Showtime.xlsx” needed to answer the question . Stat 351 Homework #5 (Section 15.8-16.1) Make sure to show your work if you did any caleulation, and Minitab output if you used Minitab. I. Please download the dataset "Showtime.xlsx" from Canvas. The dataset "Showtime.xlsx" gives the data on weekly gross revenue (y), television advertising (x1), and newspaper advertising (32) for Showtime Movie Theaters. Use Minitab to help you answer...

  • Ten communities roughly comparable in size, wealth, and purchasing powers were selected to investigate the effect of advertising expenditures on sales of electric vehicles. For each community, the ad...

    Ten communities roughly comparable in size, wealth, and purchasing powers were selected to investigate the effect of advertising expenditures on sales of electric vehicles. For each community, the advertising outlay (X, in thousands of dollars) and the sales (Y, in units sold) are shown below: dvertising Expenditure Sales 3.9 7.8 1.1 6.6 3.4 2.5 6.0 32 25 23 30 4.6 25 2.0 1. 2. 3. Find the regression equation for predicting sales from advertising expenditure. Construct the 99 percent confidence...

  • 4. The data set below shows the length of service (in years)and salaries in thousands of...

    4. The data set below shows the length of service (in years)and salaries in thousands of dollars) for 10 randomly selected employees. Length of service, 2 Salary, y 0.5 2 4 6 8 10 .75 39 41 41 40.5 42 41 40 1 6 8 38 41 42 (a) Construct a scatter plot for the data showing the regression line. (b) Find the equation of the regression line for the data. (c) Find the value of the correlation coefficient, r....

  • Data on advertising expenditures and revenue (in thousands of dollars) for the Four Seasons Restaurant follow...

    Data on advertising expenditures and revenue (in thousands of dollars) for the Four Seasons Restaurant follow Advertising Expenditures 2 4 6 10 14 20 Revenue 20 32 45 40 53 54 a. Let x equal advertising expenditures and y equal revenue. Complete the estimated regression equation below (to 2 decimals) b. Compute the following (to 1 decimal) SSE SST SSR MSR MSE c. Test whether revenue and advertising expenditures are related at a .05 level of significance. Compute the F...

  • Use Data Set D, Single Engine Aircraft Performance (Airplanes), on page 535 of your textbook to answer the following questions.

    CruiseTotalHP1001162006002416501995701743001643601413601613001071101041451221601291801442301945701704202236202347501241801862851902851905001592351602351483101433001602001401252353501913101321251151801702101752441562001882801281601071251483001291801915001472352133501863001483001804401864401001501763001512609881163250143180Use Data Set D, Single Engine Aircraft Performance (Airplanes), on page 535 of your textbook to answer the following questions. The first column is X, or the independent variable and the second column is Y, or the dependent variable. Use MINITAB to obtain the simple regression equation, confidence interval, prediction interval, and required graphs. Insert tables and graphs in your report as appropriate. Use Minitab and produce the appropriate output to answer the following questions. Attach or include the Minitab...

  • help please and thank you! Price in Dollars Number of Bids $ 108 12 $131 13...

    help please and thank you! Price in Dollars Number of Bids $ 108 12 $131 13 $136 16 $142 17 $158 19 TABLE 1 59 4.2 Completion Percentage Interception Percentage 4.9 63 64 T 3.1 - 64 2.4 64 1.8 TABLE 2 Table 1 gives the list price and the number of bids received for five randomly selected items sold through online auctions. Using this data, consider the equation of the regression line for predicting the number of bids an...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT