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

50.1K

Verified Solution

Question

Basic Math

In order to estimate the average electricity usage per month, asample of 125 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
799
911
631
975
717
1232
806
637
894
856
896
1272
1224
621
606
898
723
817
746
933
595
851
1027
770
685
750
1198
975
678
1050
886
826
1176
583
841
1188
692
733
791
584
1163
593
1234
603
1044
1233
1178
598
904
778
693
590
845
893
1028
975
788
1240
1253
854
1185
1164
741
1058
1053
795
1198
1240
1140
959
938
1008
1035
1085
1100
680
1006
977
1042
1252
943
1165
1014
912
791
612
935
864
953
667
1005
1063
1095
1086
810
1032
970
1099
1229
892
1074
579
754
1007
1116
583
763
1231
966
962
1132
738
1033
697
891
840
725
1031

Answer & Explanation Solved by verified expert

4.3 Ratings (860 Votes)

SolutionWe are given that a sample of 125 residential customerselectricity usage per month We have to use Excel to construct 98confidence interval for the mean electricity usage in 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