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.