Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. in order to estimate the average electricity usage

In order to estimate the average electricity usage per month, a sample of 40 residential customers...

90.2K

Verified Solution

Question

Basic Math

In order to estimate the average electricity usage per month, asample of 40 residential customers were selected, and the monthlyelectricity usage was determined using the customers' meterreadings. Assume a population variance of 12,100kWh2. Use Excel tofind the 98% confidence interval for the mean electricity usage inkilowatt hours. Round your answers to two decimal places and useascending order. Electric Usage 765 1139 714 687 1027 1109 749 799911 631 975 717 1232 806 637 894 856 896 1272 1224 621 606 898 723817 746 933 595 851 1027 770 685 750 1198 975 678 1050 886 826 1176583 841 1188 692 733 791 584 1163 593 1234 603 1044 1233 1178 598904 778 693 590 845 893 1028 975 788 1240 1253 854 1185 1164 7411058 1053 795 1198 1240 1140 959 938 1008 1035 1085 1100 680 1006977 1042 1252 943 1165 1014 912 791 612 935 864 953 667 1005 10631095 1086 810 1032 970 1099 1229 892 1074 579 754 1007 1116 583 7631231 966 962 1132 738 1033 697 891 840 725 1031

Answer & Explanation Solved by verified expert
4.4 Ratings (939 Votes)
To find sample mean Excel formula AVERAGEA2A125sample mean population    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

Chemistry
1.2K views

Which of the following gives a buffer solution when equal volumes of the two solutions are...

Medical Sciences
1.2K views

Cochlear Implants: How effective are these bionic devices? What are the variables that affect their performance? What...

Civil Engineering
1.2K views

What is the difference between a solidus line and asolvus line? When is the information given...

Psychology
1.2K views

1. a) A lot of experiments conducted during the 20th century - from Milgram to Harlow's...

Psychology
1.2K views

Many people have very active social media lives, and it is now quite common for potential...

Geometry
1.2K views

Glven Two Points Write the equation of the line with the two given points 5...

Basic Math
1.2K views

In its first 10 years a mutual fund produced an average annual return of 19...

Basic Math
1.2K views

When playing bingo, 50 balls are placed in a bin and balls are selected at...

Accounting
1.2K views

Windsor, Inc. began the year with 12 units of marine floats...

Accounting
1.2K views

Fill in the blanks in the following separate income statements a through e

Accounting
1.2K views

Restore Corporation produces three products and is currently facing a labor shortage; only 3,000 labor...

Finance
1.2K views

Help please QUESTION TWO (15 marks) Sample Bank Balance Sheet Year ended 31/12/2021...