SELF 3.42 The file Energy contains the per capita energy consumption, in kilowatt-hours, for each of the 50 states and the District of Columbia during a recent year. Test a. Compute the mean, variance, and standard deviation for the population. b. What proportion of these states has per capita energy con- sumption within 1 standard deviation of the mean, within +2 standard deviations of the mean, and within ±3 standard deviations of the mean? c. Compare your findings with what would be expected based on the empirical rule. Are you surprised at the results in (b)? d. Repeat (a) through (c) with the District of Columbia removed. How have the results changed?

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Topic Video
Question

please help step by step with R program with a final code for understanding thank you.

First image is problem and second image is csv

Problem#6
SELF 3.42 The file Energy contains the per capita energy
consumption, in kilowatt-hours, for each of the 50
states and the District of Columbia during a recent year.
Test
a. Compute the mean, variance, and standard deviation for the
population.
b. What proportion of these states has per capita energy con-
sumption within 1 standard deviation of the mean, within
+2 standard deviations of the mean, and within 3 standard
deviations of the mean?
c. Compare your findings with what would be expected based on
the empirical rule. Are you surprised at the results in (b)?
d. Repeat (a) through (c) with the District of Columbia removed.
How have the results changed?
Transcribed Image Text:Problem#6 SELF 3.42 The file Energy contains the per capita energy consumption, in kilowatt-hours, for each of the 50 states and the District of Columbia during a recent year. Test a. Compute the mean, variance, and standard deviation for the population. b. What proportion of these states has per capita energy con- sumption within 1 standard deviation of the mean, within +2 standard deviations of the mean, and within 3 standard deviations of the mean? c. Compare your findings with what would be expected based on the empirical rule. Are you surprised at the results in (b)? d. Repeat (a) through (c) with the District of Columbia removed. How have the results changed?
State
Wyoming
D.C
Kentucky
South Caro
Texas
North Caro
West Virgin
Ohio
Alabama
Louisiana
Idaho
Tennessee
Washingtor 16357
Indiana
Mississippi
18277
15885
Arkansas
Nevada
Georgia
North Dako
Oregon
Delaware
Oklahoma
Montana
Nebraska
Virginia
lowa
Kansas
Missouri
Florida
Wisconsin
Arizona
Minnesota
Maryland
Illinois
South Dak
Kilowatt Hours
24567
20073
Michigan
New Mexic
Utah
Colorado
Maine
Vermont
Connecticu
19970
18885
18399
17902
17453
10993
15595
15050
15033
15022
14593
14511
14465
14380
14172
13926
13918
13743
13691
13536
13255
12743
12614
12393
12103
12067
12010
11425
10903
10806
10491
10344
10273
10002
9532
9309
9081
8867
8543
8095
New Jerse
Alaska
New Hamp
Pennsylvar 8006
Hawaii
7913
Massachus 7744
New York 7135
Rhode Isla 6716
California 6396
Transcribed Image Text:State Wyoming D.C Kentucky South Caro Texas North Caro West Virgin Ohio Alabama Louisiana Idaho Tennessee Washingtor 16357 Indiana Mississippi 18277 15885 Arkansas Nevada Georgia North Dako Oregon Delaware Oklahoma Montana Nebraska Virginia lowa Kansas Missouri Florida Wisconsin Arizona Minnesota Maryland Illinois South Dak Kilowatt Hours 24567 20073 Michigan New Mexic Utah Colorado Maine Vermont Connecticu 19970 18885 18399 17902 17453 10993 15595 15050 15033 15022 14593 14511 14465 14380 14172 13926 13918 13743 13691 13536 13255 12743 12614 12393 12103 12067 12010 11425 10903 10806 10491 10344 10273 10002 9532 9309 9081 8867 8543 8095 New Jerse Alaska New Hamp Pennsylvar 8006 Hawaii 7913 Massachus 7744 New York 7135 Rhode Isla 6716 California 6396
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 3 images

Blurred answer
Knowledge Booster
Instruction Format
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education