• 100% Satisfaction Guarantee

Ryan, Engineer
Category: Calculus and Above
Satisfied Customers: 6915
Experience:  B.S. in Civil Engineering
Type Your Calculus and Above Question Here...
Ryan is online now

# 55-4For 12 straight weeks, you have observed the sales

### Resolved Question:

Attachment: 2013-11-18_185351_copy_of_s55_4.xlsx

55-4 For 12 straight weeks, you have observed the sales (in numbers of cases) of canned tomatoes at Mr. D. Supermarket. (See the file Grocery xlxs.) Each week, you keep track of the following: -Was promotional notice for canned tomatoes placed in all shopping carts? - Was a coupon for canned tomatoes given to each customer? -Was a price reduction (none, 1, or 2 cents off) given? Use this data to determine how the above factors influence sales. Predict sales of canned tomatoes during a week in which you used a shopping cart notice, a coupon, and reduce price by 1 cent.

Submitted: 3 months ago.
Category: Calculus and Above
Expert:  mathwhiz123 replied 3 months ago.

mathwhiz123 :

can you send the excel file?

Customer:

I did its attached

Expert:  Ryan replied 3 months ago.
Hi Janelle,

I reviewed the regression analysis that was done in the Excel file that you attached. I don't understand why the last column is labeled as "2 cents off". It would seem that you would want a column for the coupon (1 for yes, 0 for no), and a column for the price reduction (where the value is 0, 1, or 2, therby reflecting the actual amount of the price reduction). In other words, while the cart notice and coupon use columns are binary (either a 0 or a 1), the price reduction column should have the actual value of the reduction.

I have reworked the multiple regression in the Excel file linked below. The first analysis showed that coupon use was not significant in predicting sales, which may explain why your file seems to ignore coupon use in its analysis.

A second multiple regression analysis is then done, excluding the coupon use data. That analysis turned out to be significant, and all coefficients were significant. As a result, the equation from the second analysis is then used to make the required prediction.

Here is the file:

MultipleRegression

Thanks,

Ryan
Ryan, Engineer
Satisfied Customers: 6915
Experience: B.S. in Civil Engineering

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
• Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
• He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX

• ### Mr. Gregory White

#### Satisfied Customers:

88
M.A., M.S. Education / Educational Administration
< Last | Next >

### Mr. Gregory White

#### Satisfied Customers:

88

M.A., M.S. Education / Educational Administration

### SusanAthena

#### Satisfied Customers:

83

Tutor for Algebra, Geometry, Statistics. Explaining math in plain English.

### JACUSTOMER-yrynbdjl-

#### Satisfied Customers:

41

I have a MS in Mathematics and I have taught Mathematics for 10 years at the college level.

### dhouse1940

#### Satisfied Customers:

33

BS mathematics, MS biostatistics, 35+ yrs designing & analyzing biological experiments.

### Don

#### Satisfied Customers:

29

M.S. Astronautical Engineering. Math/Sci/Comp Tutor

### Ray Atkinson

#### Satisfied Customers:

21

Degrees in Math, Education and Accounting, years and years of tutoring.