Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. log onto website where you can observe your servic

Log onto website where you can observe your service bill for the last 12 months (electric bill,...

80.2K

Verified Solution

Question

Basic Math

Log onto website whereyou can observe your service bill for the last 12 months (electricbill, cell phone bill, water bill, etc.). If you do NOT feelcomfortable sharing this data, you can make up values.

  1. In excel, list the values of your bill for the last 12 monthson one column.
  2. Find the sample mean and sample standard deviation of yourdata.
  3. Pick three bills from the last 12 months and change the valuesinto z-scores. What does the z-score tell you about that particularmonth?

Analysis

  1. Between what two values would be considered a normal bill?Remember, being within 2 Standard Deviations is considerednormal.
  2. Are any of your bills in the last 12 months unusual? Veryunusual?
  3. Are there times when you would accept an "unusual" bill?Explain.

Answer & Explanation Solved by verified expert
4.3 Ratings (1084 Votes)
Solved below in Excel as asked If you want to replicate thesame with formulas the 2nd    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Biology
1.2K views

Describe the way in which DNA is replicated with reference to the following: (a) The formation...

Chemistry
1.2K views

Balance each of the following redox reactions occurring in basic solution. Express your answer as a chemical...

Finance
1.2K views

Choosing a sales compensation plan is an important decision. However, there is no one size fits...

Accounting
1.2K views

What are the alternatives available for accounting for inventory and advertising?

Physics
1.2K views

15 Two identical cells each of emf E and each of internal resistance r are...

Physics
1.2K views

A steel wire of length 2L and cross sectional area A is stretched within elastic...

Accounting
1.2K views

Use the following data to compute total manufacturing costs for the month. \table[[Sales...

Accounting
1.2K views

Inspection costs at one of Ratulowski Corporation's factories are listed below: Units Inspection Produced...

Accounting
1.2K views

J Suppose the following items were taken from the 2025 financial statements of Texas Instruments,...

Accounting
1.2K views

Douglas and Julie are a married couple who live in Louisiana, a community property state....

Accounting
1.2K views

The following partial income statement and balance sheet information (in $ millions) comes from the...

Finance
1.2K views

MGMT-6083 Risk Assessment Critical Review Context We have now all experienced the COVID-19 global pandemic...