Part 1Purpose:Students will explore the different meanings of “average” (mean, median, and mode). In addition, situations in which the mean and median, for example, are not the same and then determine which average would better represent the data given will be explored.Directions:Use the Activity 6 – Mean Versus Median Student Directions to complete the Activity 6 – Mean Versus Median Student Worksheet.RubricCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeQuestion 13.0 ptsGreatAll calculations and analysis are correct.2.0 ptsSome ErrorsOnly one calculation is incorrect and/or analysis is not clear.0.0 ptsIncomplete or Significant ErrorsMultiple errors in calculations and/or analysis.3.0 ptsThis criterion is linked to a Learning OutcomeQuestion 24.0 ptsGreatAll calculations and analysis are correct.3.0 ptsSome ErrorsOnly one calculation is incorrect and/or analysis is not clear.0.0 ptsIncomplete or Significant ErrorsMultiple errors in calculations and/or analysis.4.0 ptsThis criterion is linked to a Learning OutcomeQuestion 33.0 ptsGreatAll calculations and analysis are correct.2.0 ptsSome ErrorsOnly one calculation is incorrect and/or analysis is not clear.0.0 ptsIncomplete or Significant ErrorsMultiple errors in calculations and/or analysis.3.0 ptsThis criterion is linked to a Learning OutcomeAnalysis 1a3.0 ptsGreatAll calculations and analysis are correct.2.0 ptsSome ErrorsOnly one calculation is incorrect and/or analysis is not clear.0.0 ptsIncomplete or Significant ErrorsMultiple errors in calculations and/or analysis.3.0 ptsThis criterion is linked to a Learning OutcomeAnalysis 1b3.0 ptsGreatAll calculations and analysis are correct.2.0 ptsSome ErrorsOnly one calculation is incorrect and/or analysis is not clear.0.0 ptsIncomplete or Significant ErrorsMultiple errors in calculations and/or analysis.3.0 ptsThis criterion is linked to a Learning OutcomeAnalysis 2a3.0 ptsGreatAll calculations and analysis are correct.2.0 ptsSome ErrorsOnly one calculation is incorrect and/or analysis is not clear.0.0 ptsIncomplete or Significant ErrorsMultiple errors in calculations and/or analysis.3.0 ptsThis criterion is linked to a Learning OutcomeAnalysis 2b3.0 ptsGreatAll calculations and analysis are correct.2.0 ptsSome ErrorsOnly one calculation is incorrect and/or analysis is not clear.0.0 ptsIncomplete or Significant ErrorsMultiple errors in calculations and/or analysis.3.0 ptsThis criterion is linked to a Learning OutcomeAnalysis 2c3.0 ptsGreatAll calculations and analysis are correct.2.0 ptsSome ErrorsOnly one calculation is incorrect and/or analysis is not clear.0.0 ptsIncomplete or Significant ErrorsMultiple errors in calculations and/or analysis.3.0 ptsTotal Points: 25.0Part 2Yearly Budget
Project Directions:
Construct a budget sheet that assists you in analyzing your financial status, set goals, make changes, whatever the case may be. This
project will have more meaning to you the more it reflects your real life. You can use this to create a budget for your future life based
on your plans of a future job, future housing, expenses, etc. I assure you that, should you choose to include personal values, I will be
assessing your work only on if it was accurately represented and interpreted. Please work to be realistic so you can gain from the
experience. There will never be any judgement made on my part nor any information shared out.
Your sheet should address both regular and unexpected monthly expenses, necessities and luxuries, and any debts/savings plans. Your
first sheet should create a baseline budget of your expenses (list what you spend/think you will spend each month for each category
without regard to if you balance) and then create monthly and yearly budget as well as totals by category. You should have a
minimum of 10 to 15 categories with amounts for each month as well as monthly and yearly totals. Your second sheet should be
a tracking sheet for each category that tracks your expenses for each month of one year. In sheet two enter your data for three
months and leave space for entering data for the rest of the year (these can be left blank). You should have space to enter the date and
each expense under the category and month. You should have totals by category (both month and year) as well as monthly totals and
a year to date total. Totals will currently only reflect your three months you entered but should update automatically if you add data
for the remaining months. These totals should then be compared to your planned budget in sheet one by category and month. Sheet
three will be your reflection as described below. ❖ Provide visually appealing formatting to allow for quick differentiation among the categories and months and for quick
location of individual items. ❖ Provide visually appealing and correct formatting to allow for ease of data entry without disrupting the form or function
of sheet one and two. (What if electrical budget is changed from $150 to $125 a month? What if you have to add another
gas receipt for January?) ❖ Accurately calculate your totals in each category in dollars for each month on sheet two. ❖ Accurately calculate your totals in each category in dollars and percentage of total for the year on both sheet one and
sheet two. ❖ Accurately calculate your expenses and savings as new items are added to sheet two. ❖ Create two charts on sheet one that compare expenses by month and by category.
❖ Create a chart sheet two that compares actual expenses to budget amounts.Name:
Mean Versus Median
1) Sarah and Andrew were comparing prices of their favorite energy bar. Eight grocery stores
sell the PR energy bar for the following prices:
$1.09 $1.29 $1.29 $1.35 $1.39 $1.49 $1.59 $1.79
Sarah claims the average price of the candy bar is $1.37 but Andrew disagreed and said the
average price of the energy bar is actually $1.41. How did Sarah and Andrew come up with these
prices? Based on their calculations, who do you think is correct and why?
2) Ms. Smith, a math teacher, recently gave a mathematics quiz in her class. The ten quiz scores
were:
89
87
93
90
12
91
88
87
83
91
a) Based on the test scores above, would you say the class did well? Why or why not?
b) If you were Ms. Smith, which average would you use to describe the data: mean, median, or
mode?
3) Suppose that five graduating seniors on a college basketball team receive the following firstyear contract offers to play in the National Basketball Association (zero indicates that the
player did not receive a contract offer):
0
0
0
0
$10,000,000
The college claimed that the average senior on this basketball team received a $2 million
contract offer.
a) Explain how the college came up with this number and why this statement may be misleading.
b) Would another measure of central tendency be a better representative of the data? Support
your answer.
Analysis
1) As with the Part I Activity, determine which “average” would be a better fit for the data
given. Notice that the first two scenarios are very similar to those done in the activity.
Given a dataset, calculate and determine whether the mean or median would be a better
representation of the data. As you work through these two problems, be sure to calculate
BOTH the mean and median. Be careful in how you choose which “average” to use since
the question asks for a particular value.
Scenario
Mean Median
a) A retail store had total sales of $436,
$650, $530, $500, $650, $489, and $423
last week. Which measure of data would
make the store’s sales last week appear
the most profitable?
b) Suppose you have opened some
Nutty Bars to check the company’s
claim of an “average” of 8 peanuts per
bar. Here is what you found after
opening 10 bars: 5, 8, 8, 8, 11, 7, 8, 6, 6,
and 6. Which
average should the company use to
support their claim?
Explanation
2) For the second part of this activity, determine which “average” would be a better representation WITHOUT
being given a specific data set. This will require you to think about WHO is requesting or wants the data and
then determine which “average” would better suit their needs. In real-life settings, most companies like to
portray themselves in a better “light,” so you will have to think critically about how best to do that. Try to
think of all the possibilities that can occur and if you need to, “create” a data set to help you determine which
“average” to choose.
Scenario
a) The average number of pieces of lost
luggage per flight from an airline
company’s perspective
b) The average weight of potatoes in a
10- pound bag
c) The average age at first marriage for
men in America
Explanation
Mean Versus Median
Before you begin:
• Review how to calculate mean, median, and mode.
Background: As described by your readings, the term “average” is often used in multiple
contexts and does not necessarily mean taking the sum of your data and dividing by the number
of items in the dataset. Sometimes, the term “average” can be used to refer to other measures of
center, such as the median or the mode. In this activity, we will explore how the various
meanings of “average” and determine which measure of center would better represent the data.
In this activity you will:
1. Calculate mean, median, and mode of various data.
2. Explore the measures of center (mean, median, and mode) and determine which
“average” (mean or median) would be a better representation of data given.
3. Understand that data can be skewed.
4. Apply your knowledge to real-life problems and explain how a single number can
represent the nature of data.
Procedure:
1. As you work through the Part I Activity, here are some guided questions to help you in
your endeavor.
a. For problem #1, determine who is correct (Sarah or Andrew) in giving the
average price for a particular energy bar. These are some questions you should be
asking yourself:
i. How did Sarah calculate her answer?
ii. How did Andrew calculate his answer?
iii. Who do you believe is correct and why?
iv. In this particular scenario, what does the term “average” mean?
v. The price difference between Sarah’s calculations and Andrew’s
calculations may not be much, but can you think of an instance where it
would matter which “average” is used?
b. For problem #2, determine how Mrs. Smith’s class performed on a particular
quiz.
i. Part A: Before making any calculations, look at the data overall and give
your best educated guess as to how you think the students did on the quiz.
Which “average” do you think would best describe her students’
performance?
ii. Part B: Based on your observations in Part A, calculate the necessary
“average” you think will provide Mrs. Smith with the best feedback.
Which “average” did you choose and why? Now that you see the number
that represents the data, do you agree with your initial assessment in
Part A?
c. For problem #3, explain why the statement made by the college is misleading.
Here are some guiding questions to help you along the way:
i. Part A:
1. Just by looking at the data, what do we know about the 5
basketball players? Did they all receive a contract?
2. The college claimed that “the average senior on this basketball
team received a $2 million contract offer.” Which “average” are
they referring to? Do you agree/disagree with their statement?
Why or why not?
Part B:
1. How else could we calculate the “average”? Why would this
“average” be a better representation of the data?
2. How does the $10,000,000 affect the dataset as a whole? What
kinds of numbers drastically affect the dataset?
Results: Complete the Student Worksheet and turn in your completed worksheet on
Canvas.
MTH 154: Project – Yearly Budget
Project Directions:
Construct a budget sheet that assists you in analyzing your financial status, set goals, make changes, whatever the case may be. This
project will have more meaning to you the more it reflects your real life. You can use this to create a budget for your future life based
on your plans of a future job, future housing, expenses, etc. I assure you that, should you choose to include personal values, I will be
assessing your work only on if it was accurately represented and interpreted. Please work to be realistic so you can gain from the
experience. There will never be any judgement made on my part nor any information shared out.
Your sheet should address both regular and unexpected monthly expenses, necessities and luxuries, and any debts/savings plans. Your
first sheet should create a baseline budget of your expenses (list what you spend/think you will spend each month for each category
without regard to if you balance) and then create monthly and yearly budget as well as totals by category. You should have a
minimum of 10 to 15 categories with amounts for each month as well as monthly and yearly totals. Your second sheet should be
a tracking sheet for each category that tracks your expenses for each month of one year. In sheet two enter your data for three
months and leave space for entering data for the rest of the year (these can be left blank). You should have space to enter the date and
each expense under the category and month. You should have totals by category (both month and year) as well as monthly totals and
a year to date total. Totals will currently only reflect your three months you entered but should update automatically if you add data
for the remaining months. These totals should then be compared to your planned budget in sheet one by category and month. Sheet
three will be your reflection as described below.
❖ Provide visually appealing formatting to allow for quick differentiation among the categories and months and for quick
location of individual items.
❖ Provide visually appealing and correct formatting to allow for ease of data entry without disrupting the form or function
of sheet one and two. (What if electrical budget is changed from $150 to $125 a month? What if you have to add another
gas receipt for January?)
❖ Accurately calculate your totals in each category in dollars for each month on sheet two.
❖ Accurately calculate your totals in each category in dollars and percentage of total for the year on both sheet one and
sheet two.
❖ Accurately calculate your expenses and savings as new items are added to sheet two.
❖ Create two charts on sheet one that compare expenses by month and by category.
❖ Create a chart sheet two that compares actual expenses to budget amounts.
Reflection:
The reflection must be completed in Canvas. “Module 3: Project 2 – Reflection – Requires Respondus LockDown Browser +
Webcam.
Project due date: ____________________
Rubric for Reflections
Reflection Paragraph I
Reflection Paragraph II
Reflection Paragraph III
6 Points
Reflection is well
written in organization
and grammatical
structure. Demonstrate
both deep thought and
comprehensive
overview of the
project.
4 Points
Reflection is written
with poor organization
or lacking grammatical
structure. Demonstrate
some thought and
comprehensive
overview of the
project.
2 Points
Reflection is written
with poor organization
and lacking
grammatical structure.
Demonstrate little
thought and no
overview of the
project.
0 Points
No reflection
submitted.
6 Points
4 Points
10-15 categories are used.
2 Points
Missing 1 or 2 categories.
Layout, Borders,
Background color, Font,
Font size, and Font style all
work to differentiate
between each category.
The use of, Borders,
Background color, Font,
Font size, and Font style
are mostly effective to
differentiate between each
category.
The use of, Borders,
Background color, Font,
Font size, and Font style
are barely effective to
differentiate between each
category.
0 Points
Missing 3 or more
categories.
The use of, Borders,
Background color, Font,
Font size, and Font style
are not effective to
differentiate between each
category.
Rubric for Sheet One and Two
Sheet one minimum number of
categories used
Sheet one formatting and
labeling
Sheet one ease of data
change/entry
Entry of data is easy, cell
has correct formatting, and
does not cause disruption
in the form or function of
the workbook
Data is easy to enter, but
some cells do not have
proper formatting for the
data.
The form or function of the
workbook is not disrupted.
1 or 2 totals are missing or
incorrect.
1 or 2 percentages are
missing or incorrect.
The form or function of the
workbook is disrupted
when some data is entered
and some cells do not have
the proper formatting.
Sheet one all requested totals
included and correct
Sheet one all requested
percentages included and
correct
Sheet one chart comparing
categories
All totals are on sheet and
correct.
All percentages are on
sheet and correct.
The chart is completely
labeled, including axes,
title and legend. It
accurately reflects the data.
The chart is missing a
legend or one of the axis
has not been labeled.
The chart is missing three
or more labels.
Sheet one chart comparing
months
The chart is completely
labeled, including axes,
title and legend. It
accurately reflects the data.
The chart is missing a
legend or one of the axis
has not been labeled.
Sheet two minimum number of
months data included with
space for all months
3 months of data are
included and space is
included of the additional 9
months.
Layout, Borders,
Background color, Font,
Font size, and Font style all
work to differentiate
between each category.
3 months of data are
included bit space is not
included of the additional 9
months.
The use of, Borders,
Background color, Font,
Font size, and Font style
are mostly effective to
differentiate between each
category.
Data is easy to enter, but
some cells do not have
proper formatting for the
data.
The form or function of the
workbook is not disrupted.
Adding additional data will
automatically update most
calculations.
1 or 2 totals are missing or
incorrect.
1 or 2 percentages are
missing or incorrect.
The chart is missing two or
more labels or a legend and
the chart does not
accurately reflect the data
in the two indicated
categories.
The chart is missing two or
more labels or a legend and
the chart does not
accurately reflect the data
in the two indicated
categories.
Only 2 months of data is
included.
The use of, Borders,
Background color, Font,
Font size, and Font style
are barely effective to
differentiate between each
category.
The form or function of the
workbook is disrupted
when some data is entered
and some cells do not have
the proper formatting.
The use of, Borders,
Background color, Font,
Font size, and Font style
are not effective to
differentiate between each
category.
The sheet does not function
properly, making data
entry almost impossible.
This can be due to
formatting issues or issues
with the layout.
Adding additional data will
not automatically update
calculations.
5 or more totals are
missing or incorrect.
5 or more percentages are
missing or incorrect.
Sheet two formatting and
labeling
Sheet two ease of data
change/entry
Entry of data is easy, cell
has correct formatting, and
does not cause disruption
in the form or function of
the workbook
Sheet two calculations correct
when new items added
Adding additional data will
automatically update all
calculations.
All totals are on sheet and
correct.
All percentages are on
sheet and correct.
Sheet two all requested totals
included and correct
Sheet two all requested
percentages included and
correct
Sheet two chart comparing
budget to actual
The chart is completely
labeled, including axes,
title and legend. It
accurately reflects the data.
The chart is missing a
legend or one of the axis
has not been labeled.
3 or 4 totals are missing or
incorrect.
3 or 4 percentages are
missing or incorrect.
Adding additional data will
automatically update some
calculations.
3 or 4 totals are missing or
incorrect.
3 or 4 percentages are
missing or incorrect.
The chart is missing two or
more labels or a legend and
the chart does not
accurately reflect the data
in the two indicated
categories.
The sheet does not function
properly, making data
entry almost impossible.
This can be due to
formatting issues or issues
with the layout.
5 or more totals are
missing or incorrect.
5 or more percentages are
missing or incorrect.
The chart is missing three
or more labels.
Only one months of data is
included
The chart is missing three
or more labels.
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.