Math 1220 1. modeling the data linearly: a. generated a linear model

MATH 1220
1. Modeling the data linearly:
a. Generated a linear model by choosing two points for this data. Linear Model for WalMart
Dry Goods Sales 2002-2003
25000
21200 20000
15200 15000
Sales in $ 10000
5000
0
20 30 40 50 60 70 80 Week b. Generate a least square linear regression model Least Square Linear Regression Model
35000
30000
25000
20000
Sales in $ Sales in $
Linear (Sales in $) 15000
10000
5000
0
20 30 40 50 Week Regression StatisticsY=ax+b 60 70 80 R
0.806575
2
R
0.650563
Adjusted R2
Standard Error
Observations 0.643574
2030.33
52 c. How good is this regression model?
d. What is the marginal revenue for this department using the linear model
with two data points and the regression model? Note that marginal revenue is
the same as the first derivative of the revenue (sale) function.
(Im not sure if this is right)
The marginal revenue function is the first derivative of the total revenue function. so
S=8741.97+180.99w
TR=(8741.97+180.99w)w
MR=8741.97+361.999w
e. Compare the two models. Which do you feel is better?
After comparing the two models, I find that the least square regression model is
better. Although this is a simple linear least squares regression model because there
is only one variable, it is still more effective and complete as compared to the linear
model. The estimates of the unknown parameters obtained from linear least squares
regressions are the optimal estimates from a broad class of possible parameter
estimates under the usual assumptions used for process modeling. Practically
speaking, linear least squares regression makes very efficient use of the data. Good
results can be obtained with relatively small data sets. Aside, the linear model only
takes into account two points and not the whole set of data. 2. Modeling the data quadratically:
a. Generate a quadratic model for this data.
QuadReg. Formula (Y=AX2+BX+C)
A= 3.357
B=-164.762
C=16889.187
R2=.691
b. What is the marginal revenue for this department using this model?
c. Calculate the model generated relative max/min value. Show backup analytical
work. d. Compare actual and model generated relative max/min value. 3. Comparing models
a. Which model do you feel best predicts future trends? Explain your rationale.
b. Based on the model selected, what type of seasonal adjustments, if any, would be
required to meet customer needs?
4. Identify holiday periods or special events that cause spikes in the original
data.
WalMart weeks start the beginning of February. So, for example, Walmart week 30 in
the 2002 is actually week 34 (30 + 4) in the calendar year 2002 which equates to the
end of August 2002. To make the weeks continuous, week 53 is actually WalMart
week 1 in 2003 and this equates to week 5 (53 – 52 +4) or the first week in February
2003. Week 72 is week 24 (72 – 52 + 4) in the year 2003 or mid June 2003.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more