Question

The following data represent a company's yearly sales volume and its advertising expenditure over a period...

The following data represent a company's yearly sales volume and its advertising expenditure over a period of 8 years.

(Y) Sales in Millions of Dollars (X) Advertising in ($10,000)

15 32

16 33

18 35

17 34

16 36

19 37

19 39

24 42

Develop a 95% confidence interval for predicting the average sales for the years when $400,000 was spent on advertising.

i. Compute the correlation coefficient. alpha=5

urgently need detailed solution please

Homework Answers

Know the answer?
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
Similar Questions
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 8 years.              Sales (Millions) Advertising ($10,000) 15 32 16 33 18 35 17 34 16 36 19 37 19 39 24 42 To make sure the Excel regression package is installed. Click “Tools”, à“Add-Ins” àchoose “Analysis Toolpak” and click “OK”. To use the Excel regression package,                                                       Click “Tools”, à“Data Analysis” and click “Regression”.    f.    Use the F test to determine whether or not...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 5 years. (y) sales in millions of dollars (x) advertising in ($10,000) 15 32 16 33 18 35 17 34 16 36 Use the method of least squares to compute an estimated regression line between sales and advertising by computing b0 and b1. If the company's advertising expenditure is $400,000, what are the predicted sales? Give the answer in dollars. What does the...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 5 years. (Y) Sales in Advertising (X) Millions of Dollars in ($10,000) 15 32 16 33 18 35 17 34 16 36 (a) Compute the coefficient of determination for the estimated regression equation you got in the previous in-class problem. (b) Interpret the meaning of the value of the coefficient of determination that you found in (a). Be very specific. (c) Perform a...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and its advertising expenditure over a period of 8 years. Advertising (x) Sales (y) 400,000 6,000,000 500,000 7,200,000 500,000 8,000,000 660,000 7,500,000 790,000 8,900.000 540,000 8,100,000 420,000 5,900.000 380,000 4,000,000 Develop a scatter diagram of sales versus advertising. Include the trendline equation and the coefficient of determination. If the company's advertising expenditure is $315,000, what are the predicted sales? If the company wanted $9,500,000 in sales, what should the advertising budget...
Use the following data to test if there is a difference in mean age between mothers...
Use the following data to test if there is a difference in mean age between mothers of a boy and mothers of a girl at alpha =0.05. provide p-value     MomAge gestation sex weight preemie 35 39 F 3175 FALSE 22 42 F 3884 FALSE 35 39 F 3030 FALSE 23 40 F 3629 FALSE 23 42 F 3481 FALSE 25 38 F 2693 FALSE 25 40 F 3345 FALSE 24 40 F 3232 FALSE 19 40 F 2795 FALSE 20...
Sandra is the manager of human resources at ABC Inc. As part of his yearly report...
Sandra is the manager of human resources at ABC Inc. As part of his yearly report to the CEO she is required to present an analysis of the salaried employees. Because there are over 1,000 employees, she does not have the staff to gather information on each salaried employee, so she selects a random sample of 40. For each employee she records monthly salary, service at ABC (in months), gender (1=male, 0=female), and whether the employee has a technical or...
"Advertising": A. is the only form of mass selling. B. is also called "sales promotion." C....
"Advertising": A. is the only form of mass selling. B. is also called "sales promotion." C. is concerned with "promotion" using samples, coupons, and contests. D. involves direct spoken communication between sellers and potential customers. E. is any paid form of nonpersonal presentation of ideas, goods, or services by an identified sponsor. 31. "Publicity": A. is generally less useful than advertising for promoting a truly new product. B. is mass selling that avoids paying media costs. C. is any paid...
A study was conducted to investigate the influence of a driver's age, number of driving years...
A study was conducted to investigate the influence of a driver's age, number of driving years and attention span (the higher, the more detailed) on the number of speeding tickets within the last five years. Given a driver at age 30, who has been driving for 10 years with an attention span score of 5, what is the number of tickets that can be expected? TICKETS AGE YEARS SPAN 8 32 16 7 6 35 19 10 5 24 10...
a. Copy the data file SmallComp (data on America’s top 40 best small companies of 2010...
a. Copy the data file SmallComp (data on America’s top 40 best small companies of 2010 as rated on Forbes.com on 6/14/2011). Use MegaStat to construct a box plot and a dot plot (under Descriptive Statistics) for the variable Sales Growth (annual %). Be careful when column label takes up more than one cell (row). PRINT both plots to hand in. (2 pts.) b. Explain how these data illustrate a good example of an “outlier.” (1 pt.) c. Explain whether...
To raise awareness of its capabilities, FedEx developed a sales promotion that was sent to selected...
To raise awareness of its capabilities, FedEx developed a sales promotion that was sent to selected offices. To assess the possible benefit of the promotion, FedEx pulled the shipping records for a random sample of 50 offices that received the promotion and another random sample of 75 that did not and collected data on the number of mailings. They want to see if those who received the sales promotions shipped more mailings. The complete set of results is provided below:...