MAT 121 Wilmington University Poptastic Revenue Project

Description

Completing project, instructions are included in first attachment. Including finding the mean, medium and mode. I have attached the rubric as well!

2 attachmentsSlide 1 of 2attachment_1attachment_1attachment_2attachment_2

Unformatted Attachment Preview

Fall 2020 MAT205 Project #2
Once you understand descriptive statistics and can calculate statistical measures by hand, the
ability to use spreadsheet formulas to assist with these calculations saves a lot of time and
energy. Those who use statistics in the workforce for decision making, predictions, etc. will tell
you that it is very important to understand descriptive statistics and be able to calculate
statistical measures by hand, but it is even more important to understand the results and apply
them to scenarios.
Case study: You are the owner of “Poptastic”. For the past 12 months, to help supplement your
weekends in your hometown of Key West, FL. You want to take a close look at your monthly
revenues for the year (rounded to the nearest dollar):
January
February
March
April
May
June
July
August
Septembe
r
October
November
December
\$2190
\$1820
\$3090
\$314
0
\$354
0
\$459
0
\$521
0
\$4730
\$3900
\$3540
\$3250
\$2620
In this project, you will use spreadsheet formulas (via Microsoft Excel or Google Sheets) to find
the following for your monthly revenues (watch the Kaltura demo video in our Week 6 Checklist
announcement to see how to do these calculations on an example set of data in Excel):
1.
2.
3.
4.
5.
Mean
Median
Mode
Range
Standard deviation
You will also create the following visuals with your data:
1. Bar graph
2. Line graph
You will then use these results and visuals to make a few decisions going forward for your
(in blue font please so it stands out):
1. Which visual do you feel most clearly communicates your monthly revenue for the year,
the bar graph or the line graph? Why?
2. What do you feel is the best measure of central tendency for your business, the mean,
median, or mode? Why?
3. You are considering hiring some part-time help so that you can sell popsicles all
throughout the week. Which month(s) do you feel would be best to sell all throughout
the week? Why?
4. Based on a friend’s analysis of your business (he is a business consultant), he says it
would be best to only hire part-time work for months where monthly revenue was more
than 1 standard deviation above the mean. According to his advice, which months
should you hire part-time help?
graph and line graph from Excel (or Google Sheets) as demonstrated in the demo video I
created. Then answer the last 4 questions above directly in this Word document, using blue
font to make it stand out. You will need to submit both the Excel file and Word file in Canvas.
If you do not own a copy of Microsoft Excel, you can also use Google Sheets (a demo on how to
use Google Sheets is also included in the video found in our Week 6 Checklist announcement).
If you have a Gmail account, you already have access to this. If you don’t have a Gmail account,
you will need to set one up to access and use Google Sheets.
Fall 2020 MAT205 Project #2 Rubric
Category/points 0
1-8
9-16
17-24
25
Excel or Google No Excel or
Sheets
submitted
Very few
were
completed in
Excel or
Some project
completed in
Excel or
Sheets
Most project
completed in
Excel or
All project
completed in
Sheets
Formulas
(requested for
use) in Excel or
Very few
Excel or
formulas were
used. Some
may not have
been used
correctly
Some Excel
Sheets
formulas
were used.
Some may
not have
been used
correctly
Excel or
Sheets
graphs were
created
incorrectly,
but graph
title and axis
titles are
present
The bottom
1-3 of the
questions at
the bottom
of the
project
Word doc
were
Most were
correctly
Most Excel or
formulas were
used. Some
may not have
been used
correctly
All Excel or
formulas were
used and were
used correctly
Excel or
graphs were
created
correctly, but
graph title
and/or axis
titles are
missing
Sheets graphs
were created
correctly,
including the
graph title and
axis titles
The bottom 4
questions at
the bottom of
the project
Word doc were
Most were
correctly
The bottom 4
questions in the
project Word
doc were
correctly
No Excel or
Sheets
formulas
were used
Graphs in
No Excel or
Sheets
Sheets graphs
were created
Excel or
graphs were
created
incorrectly.
Graph title
and axis titles
are missing
Bottom 4
questions in the
Project Word
doc
1-3 of the
questions at
the bottom of
the project
Word doc
were
Some may not
have been
correctly
The bottom 4
questions in
the project
Word
document
were not

attachment

Tags:
standard deviation

Statistical measures

descriptive statistics

BAR GRAPH

CENTRAL TENDENCY

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

Reviews, comments, and love from our customers and community:

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.

Peter M.
So far so good! It's safe and legit. My paper was finished on time...very excited!
Sean O.N.
Experience was easy, prompt and timely. Awesome first experience with a site like this. Worked out well.Thank you.
Angela M.J.
Good easy. I like the bidding because you can choose the writer and read reviews from other students
Lee Y.
My writer had to change some ideas that she misunderstood. She was really nice and kind.
Kelvin J.
I have used other writing websites and this by far as been way better thus far! =)
Antony B.
I received an, "A". Definitely will reach out to her again and I highly recommend her. Thank you very much.