Submit paper details for free using our simple order form

Add funds to your account. There are no upfront payments. The writer will only be paid once you have approved your paper

The best qualified expert writer is assigned to work on your order
Your paper is written to standard and delivered as per your instructions

Download the completed paper from your online account or your email
You can request a plagiarism and quality report along with your paper

August 7, 2022 by admin

Project #1

Google
5.0

Sitejabber
4.9

Eliteacademic
4.9

MATH.1220

Management Calculus

Project #1

WalMart Sales of Boxed Foods within the Dry Goods Dept 2002-2003

The following items are a guide for responses to be addressed in project one. Note that WalMart’s fiscal year starts the first week of February. This means that when analyzing the data, week 26 is actually week 30 (26+4 weeks for January) in 2002 or the end of July 2002. Also, week 52 is actually week 4 (52+4 weeks for January 2002 minus 52 weeks for 2002) in 2003 or the end of January 2003. Outliers (extreme values) are present in the data and can distort modeling results. As an example, spikes in sales (revenue) at weeks 28-30 occurs in weeks 32-34 (28+4 and 30+4) which represent mid to late August 2002. Another spike at week 58 week is actually week 10 in 2003 (58+4 weeks for January 2002 minus 52 weeks for 2002). This corresponds to sales for early March 2003. The question is whether these spikes are due to special events or holiday periods, or are perhaps due to restocking and stock availability.

All projects must be printed on 8.5×11 paper in a word document with imbedded Excel graphs. No electronic copies or handwritten ones will be accepted. All content must be printed – no handwritten mathematics, graphs, labels, etc. All projects must be stapled.

The final project report is to be an individual effort. Collaboration during the report development is acceptable as part of the learning process.

When doing your least squares modeling of the data, don’t forget to generate the model (linear or quadratic) and then remove outliers (extreme values causing spikes in the data) and rerun the model. The results should improve with better R2 values. Discuss what outliers were removed and why.

Generate supporting Excel graphs (use scatter plots) to answer the following questions for the given data:

Identify spikes (outliers) in the data where extreme sales values occur and correlate these spikes with actual calendar dates in 2002 or 2003 and with events that may occur during these periods.

Modeling the data linearly –

Generate a linear model for this data by choosing two points.

Generate a least squares linear regression model for this data.

How good is this regression model? Output and discuss the R2 value.

What are the marginal sales (derivative, i.e. rate of change) for this department using

the linear model with two data points and the regression model?

Compare the two models. Which do you feel is better?

Remove appropriate outliers as you deem necessary and rerun the linear regression

model. What is the marginal sales and discuss improvements.

Modeling the data quadratically –

Generate a quadratic model for this data. Also output and discuss the R2 value.

What are the marginal sales for this department using this model?

Calculate the model generated relative max/min value. Show backup analytical work.

Compare actual and model generated relative max/min value.

e. Remove outliers and rerun the quadratic least squares model. What is the marginal sales and discuss improvements.

4. Comparing models

Based on all models run, which model do you feel best predicts future trends? Explain

your rationale.

Based on the model selected, what type of seasonal adjustments, if any, would be

required to meet customer needs?

INCLUDEPICTURE “/var/folders/sj/7_tfwmrj25j4t9l38_4mgww00000gn/T/com.microsoft.Word/WebArchiveCopyPasteTempFiles/page1image685553920” * MERGEFORMATINET

to a single pdf file if you choose. Copy and paste your Excel files to your Word

INCLUDEPICTURE “/var/folders/sj/7_tfwmrj25j4t9l38_4mgww00000gn/T/com.microsoft.Word/WebArchiveCopyPasteTempFiles/page1image685471472” * MERGEFORMATINET

document. Send me a pdf or MS Word version of your final project.

INCLUDEPICTURE “/var/folders/sj/7_tfwmrj25j4t9l38_4mgww00000gn/T/com.microsoft.Word/WebArchiveCopyPasteTempFiles/page1image684757264” * MERGEFORMATINET

When doing your least squares modeling of the data, don’t forget to generate the model

(linear or quadratic) and then remove outliers (extreme values causing spikes in the

data) and rerun the model. The results should improve with better R^2 values. Discuss

what outliers were removed and why.

The file project 1 online requirements lists details for what is to be done. Write your

report as if you are a consultant to WalMart in an expository format. The Excel cheat

sheet file provides contains brief steps for Excel 2016 to generate your Excel charts,

add trendlines, set up headings and axes titles, reset min and max values for axes, and

move the chart to a separate page. You should find it useful. The sample scattergram

project 1 for online pdf file exhibits what your scattergram should look like. The Boxed

Foods goods data Excel file provides the data to work with.

Excel 2016 cheat sheet

The following should guide you through creating charts for Excel 2016. Start by referencing your text (p.635-636).

Enter data with headingsHighlight the headings and data, insert tab->select scattergram (use entry for points in the top left or use the entry for straight lines and markers in the 2nd row far right)Right click any point in the graph->select add trendline, select: linear, display equation on chart, display R-squared->closeUnder chart tools in the upper right ( click anywhere on the chart in empty space if chart tools doesn’t appear)->click on layout->chart title->enter “Boxed Foods”, then axes titles->horizontal- >enter “weeks”, then axes titles->vertical->enter “sales’Right click any value on the horizontal axis->select format axis->reset the min and max values as desiredRight click on the chart in empty space ->select “move chart”->click on new sheet to get a separate page for the chart. Be sure to save your file!

Note: If the formula->font->change the size to a larger size as needed->ok.

it is necessary to increase the text size of your Excel trendline generated formula, right click on

[A.] Project – Analysis & Requirements

1. Analyze the given Walmart Boxed Foods 2002-2003 data set that is part of the Dry Goods department. Correlate the major spikes of the data with that of the major holiday periods cited in the 2002-2003 calendar year.Identify holiday periods or special events that cause the spikes in the data. Present your analysis result in a table format showing:

Wks-No, Spike-Sales-Value, and Calendar period

2. Generate linear and quadratic models using regression for the data set. Present your plots with appropriate titles, the axes labeled and showing the model equation and R2 value. Refer to the project requirements file for detailed instructions to be followed.

WHAT OUR CURRENT CUSTOMERS SAY

Google

Sitejabber

Trustpilot

This page is having a slideshow that uses Javascript. Your browser either doesn't support Javascript or you have it turned off. To see this page as it is meant to appear please use a Javascript enabled browser.

Zahraa S

Absolutely spot on. I have had the best experience with Elite Academic Research and all my work have scored highly. Thank you for your professionalism and using expert writers with vast and outstanding knowledge in their fields. I highly recommend any day and time.

Stuart L

Thanks for keeping me sane for getting everything out of the way, I’ve been stuck working more than full time and balancing the rest but I’m glad you’ve been ensuring my school work is taken care of. I'll recommend Elite Academic Research to anyone who seeks quality academic help, thank you so much!

Mindi D

Brilliant writers and awesome support team. You can tell by the depth of research and the quality of work delivered that the writers care deeply about delivering that perfect grade.

Samuel Y

I really appreciate the work all your amazing writers do to ensure that my papers are always delivered on time and always of the highest quality. I was at a crossroads last semester and I almost dropped out of school because of the many issues that were bombarding but I am glad a friend referred me to you guys. You came up big for me and continue to do so. I just wish I knew about your services earlier.

Cindy L

You can't fault the paper quality and speed of delivery. I have been using these guys for the past 3 years and I not even once have they ever failed me. They deliver properly researched papers way ahead of time. Each time I think I have had the best their professional writers surprise me with even better quality work. Elite Academic Research is a true Gem among essay writing companies.

Got an A and plagiarism percent was less than 10%! Thanks!

prev next

ORDER NOW

August 7, 2022 by admin

Project 1

Google
5.0

Sitejabber
4.9

Eliteacademic
4.9

The Discussion Board (DB) is part of the core of online learning. Classroom discussion in an online environment requires the active participation of students and the instructor to create robust interaction and dialogue. Every student is expected to create an original response to the open-ended DB question as well as engage in dialogue by responding to posts created by others throughout the week. At the end of each unit, DB participation will be assessed based on both level of engagement and the quality of the contribution to the discussion.

At a minimum, each student will be expected to post an original and thoughtful response to the DB question and contribute to the weekly dialogue by responding to at least two other posts from students. The first contribution must be posted before midnight (Central Time) on Wednesday of each week. Two additional responses are required after Wednesday of each week. Students are highly encouraged to engage on the Discussion Board early and often, as that is the primary way the university tracks class attendance and participation.

The purpose of the Discussion Board is to allow students to learn through sharing ideas and experiences as they relate to course content and the DB question. Because it is not possible to engage in two-way dialogue after a conversation has ended, no posts to the DB will be accepted after the end of each unit.

Assignment Details

Part 1

Research a photographer.

Choose 1 photographer from the following list:
- Edward Weston
- Julia Margaret Cameron
- Henri Cartier-Bresson
- Berenice Abbott
- Ansel Adams
- Carrie Mae Weems
Use the textbook, intellipath material, the Internet, and the Unit Resources for help.

Choose a Photograph.

Choose 1 photograph of your chosen artistâ€™s work.
List the photographerâ€™s name, the title of the photograph, and the date it was taken.
Upload your photo, pasting it directly into the Discussion Board window. Do not post an attachment.
Click here for help on How to Post Photos to the Discussion Board.

Discuss Your Choice.

Why did you choose this photographer?
Explain at least 1 of the purposes and functions of the artistâ€™s work. (See the text for more information about the purposes and functions of art.)

Part 2

Create Your Photograph.

Inspired by the photography of your chosen artist, create a similar photograph of your own using your phone, a camera, or any other photographic device.
Explain how your photograph is similar in subject matter and content.
Upload your photo pasting it directly into the Discussion Board window. Do not post an attachment.

Click here for help on How to Post Photos to the Discussion Board.

Respond to 2 classmates with substantive posts. You will be graded on the quality of your postings.

In your own words, please post a response to the Discussion Board and comment on other postings. You will be graded on the quality of your postings.

For assistance with your assignment, please use your text, Web resources, and all course materials. Please refer to the following multimedia course material(s):

Unit 1: World of Art: Functions & Evaluations
Unit 1: Referencing Art and Times
Unit 1: What is Art?

Grading Rubric

Purpose of Assignment and Content Development	Demonstrates an outstanding use of appropriate, relevant, and compelling content with excellent expression of topic, main idea, and purpose. Demonstrates exemplary knowledge or analysis of human perspectives appropriate to the assignmentâ€™s purpose and context. Graphics accurately reflect the assignment requirements.	30%
Critical Thinking	Demonstrates outstanding or exemplary ability to analyze assumptions and evaluate evidence, complexities of issues, and alternatives. Where required, demonstrates outstanding or exemplary ability to use creativity and originality in problem-solving.	30%
Organization, Grammar and Presentation (including Information Literacy)	Organization is clear. Language clearly and effectively communicates ideas and content relevant to the assignment. Presentation and delivery are confident and persuasive (where applicable). Audience, style, tone and perspective are consistent and appropriate to assignment. Few if any errors in grammar, spelling, and sentence structure. Demonstrates outstanding selection and use of high quality, credible, and relevant sources to develop ideas that are appropriate to the assignment. Sources are consistently cited according to required style sheet (e.g., APA), with no errors beyond punctuation. Manuscript style is completely correct, according to style sheet guidelines.	25%
Interactive Participation	Demonstrate active interaction and participation throughout the week and substantive responses to at least 2 posts in addition to posting the DB assignment post.	15%

Other Information

There is no additional information to display at this time.

Legend

Extra Credit

View Assignment Rubric