examples of quCategorical vs.example of catcalculator - BinData Dictionaryordinal scale-New tabWhat observatiUntitled.pXDevelop a freqfile:///C:/Users/x00x/Downloads/_Untitled.pdfA2of 1117103(Ine wora Amanac, 2000).Population StateStatePopulation StatePopulationLouisianaMaineAlabama4.54.5OhioOklahoma11.53.5AlaskaArizona0.71.3Maryland5.75.6OregonPennsylvaniaRhode Island3.6Arkansas2.8Massachusetts6.412.4MichiganMinnesotaCalifornia35.910.11.1WEB fileColorado4.65.1South Carolina4.2ConnecticutDelawareMississippiMissouriSouth DakotaTennessee3.52.90.8Population0.85.85.922.52.4FloridaGeorgiaHawaii17.4Montana0.9Texas8.8Nebraska1.7UtahVermontVirginiaWashingtonWest VirginiaWisconsinNevadaNew HampshireNew JerseyNew Mexico1.32.30.67.5Idaho1.41.3IllinoisIndiana12.78.76.21.91.86.2Iowa3.0New York19.28.55.5WyomingKansas2.7North CarolinaNorth Dakota0.5Kentucky4.10.6Develop a frequency distribution, a percent frequency distribution, and a histogramUse a class width of 2.5 millionb.a.Discuss the skewness in the distributionWhat observations can you make about the population of the 50 states?C.45.Drug Store News (September 2002) provided data on annual pharmacy sales for the leadingpharmacy retailers in the United States. The following data are annual sales in millions.RetailerRetailerSalesSales$ 175786372150116607250Medicine ShoppeRite-AidSafewayWalgreensWal-Mart$17001270077391863Ahold USACVSEckerdKmartKroger3400Show a stem-and-leaf displayIdentify the annual sales levels for the smallest, medium, and largest drug retailers.a.b11:16 PM

Question
Asked Sep 16, 2019
examples of qu
Categorical vs.
example of cat
calculator - Bin
Data Dictionary
ordinal scale-
New tab
What observati
Untitled.pX
Develop a freq
file:///C:/Users/x00x/Downloads/_Untitled.pdf
A2
of 1117
103
(Ine wora Amanac, 2000).
Population State
State
Population State
Population
Louisiana
Maine
Alabama
4.5
4.5
Ohio
Oklahoma
11.5
3.5
Alaska
Arizona
0.7
1.3
Maryland
5.7
5.6
Oregon
Pennsylvania
Rhode Island
3.6
Arkansas
2.8
Massachusetts
6.4
12.4
Michigan
Minnesota
California
35.9
10.1
1.1
WEB file
Colorado
4.6
5.1
South Carolina
4.2
Connecticut
Delaware
Mississippi
Missouri
South Dakota
Tennessee
3.5
2.9
0.8
Population
0.8
5.8
5.9
22.5
2.4
Florida
Georgia
Hawaii
17.4
Montana
0.9
Texas
8.8
Nebraska
1.7
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Nevada
New Hampshire
New Jersey
New Mexico
1.3
2.3
0.6
7.5
Idaho
1.4
1.3
Illinois
Indiana
12.7
8.7
6.2
1.9
1.8
6.2
Iowa
3.0
New York
19.2
8.5
5.5
Wyoming
Kansas
2.7
North Carolina
North Dakota
0.5
Kentucky
4.1
0.6
Develop a frequency distribution, a percent frequency distribution, and a histogram
Use a class width of 2.5 million
b.
a.
Discuss the skewness in the distribution
What observations can you make about the population of the 50 states?
C.
45.
Drug Store News (September 2002) provided data on annual pharmacy sales for the leading
pharmacy retailers in the United States. The following data are annual sales in millions.
Retailer
Retailer
Sales
Sales
$ 1757
8637
2150
11660
7250
Medicine Shoppe
Rite-Aid
Safeway
Walgreens
Wal-Mart
$1700
12700
7739
1863
Ahold USA
CVS
Eckerd
Kmart
Kroger
3400
Show a stem-and-leaf display
Identify the annual sales levels for the smallest, medium, and largest drug retailers.
a.
b
11:16 PM
help_outline

Image Transcriptionclose

examples of qu Categorical vs. example of cat calculator - Bin Data Dictionary ordinal scale- New tab What observati Untitled.pX Develop a freq file:///C:/Users/x00x/Downloads/_Untitled.pdf A2 of 1117 103 (Ine wora Amanac, 2000). Population State State Population State Population Louisiana Maine Alabama 4.5 4.5 Ohio Oklahoma 11.5 3.5 Alaska Arizona 0.7 1.3 Maryland 5.7 5.6 Oregon Pennsylvania Rhode Island 3.6 Arkansas 2.8 Massachusetts 6.4 12.4 Michigan Minnesota California 35.9 10.1 1.1 WEB file Colorado 4.6 5.1 South Carolina 4.2 Connecticut Delaware Mississippi Missouri South Dakota Tennessee 3.5 2.9 0.8 Population 0.8 5.8 5.9 22.5 2.4 Florida Georgia Hawaii 17.4 Montana 0.9 Texas 8.8 Nebraska 1.7 Utah Vermont Virginia Washington West Virginia Wisconsin Nevada New Hampshire New Jersey New Mexico 1.3 2.3 0.6 7.5 Idaho 1.4 1.3 Illinois Indiana 12.7 8.7 6.2 1.9 1.8 6.2 Iowa 3.0 New York 19.2 8.5 5.5 Wyoming Kansas 2.7 North Carolina North Dakota 0.5 Kentucky 4.1 0.6 Develop a frequency distribution, a percent frequency distribution, and a histogram Use a class width of 2.5 million b. a. Discuss the skewness in the distribution What observations can you make about the population of the 50 states? C. 45. Drug Store News (September 2002) provided data on annual pharmacy sales for the leading pharmacy retailers in the United States. The following data are annual sales in millions. Retailer Retailer Sales Sales $ 1757 8637 2150 11660 7250 Medicine Shoppe Rite-Aid Safeway Walgreens Wal-Mart $1700 12700 7739 1863 Ahold USA CVS Eckerd Kmart Kroger 3400 Show a stem-and-leaf display Identify the annual sales levels for the smallest, medium, and largest drug retailers. a. b 11:16 PM

fullscreen
check_circleExpert Solution
Step 1

a.

Frequency distribution and Percent frequency distribution:

The frequency distribution is calculated by dividing the frequency of the state by the total frequency. Multiplying this value with 100 gives the value of percent frequency distribution.

The frequency distribution and percent frequency distribution is given in the following table.

Percentage
Frequency frequency
Frequency distribution distribution
0.307
Percentage
Frequency frequency
Frequency distribution distribution
State
State
Alabama
Alaska
Arizona
Arkansas
California
Montana
Nebraska
Nevada
New
Hampshire
New Jersey
New Mexico
0.9
0.003
0.006
4.5
0.0154
0.0024
0.0195
1.5364
1.7
0.580
0.7
0.2390
2.3
0.008
0.785
5.7
1.9461
0.9560
0.004
0.030
0.444
1.3
2.8
0.0096
8.7
2.970
0.1226
0.0157
35.9
12.2567
1.5705
1.9
0.006
0.649
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
4.6
0.066
New York
North
19.2
6.555
3.5
0.0119
1.1949
0.029
Carolina
8.5
2.902
0.8
0.0027
0.2731
North
5.9406
17.4
0.0594
Dakota
0.6
0.002
0.205
3.926
0.0300
8.8
3.0044
Ohio
11.5
0.039
1.3
0.0044
0.4438
0.4780
4.3360
Oklahoma
Oregon
Pennsylvania 12.4
Rhode Island 1.1
South
Carolina
3.5
0.012
1.195
1.4
0.0048
1.229
3.6
0.012
Illinois
0.042
4.234
12.7
0.0434
0.004
0.376
Indiana
0.0212
6.2
2.1168
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
3
0.0102
1.0242
0.014
4.2
1.434
2.7
0.0092
0.9218
South
Dakota
0.8
0.003
0.273
0.0140
1.3998
4.1
Tennessee
5.9
0.020
2.014
4.5
0.0154
1.5364
Texas
22.5
0.077
7.682
1.3
0.0044
0.4438
Utah
0.008
0.819
2.4
5.6
0.0191
1.9119
Vermont
0.6
0.002
0.205
Massachusetts
2.1850
6.4
0.0219
Virginia
7.5
0.026
2.561
Washington 6.2
10.1
0.021
Michigan
Minnesota
Mississippi
Missouri
0.0345
3.4483
2.117
West
5.1
0.0174
1.7412
Virginia
Wisconsin
Wyoming
1.8
0.006
0.615
2.9
0.0099
0.9901
5.5
0.019
1.878
5.8
0.0198
1.9802
0.171
0.5
0.002
help_outline

Image Transcriptionclose

Percentage Frequency frequency Frequency distribution distribution 0.307 Percentage Frequency frequency Frequency distribution distribution State State Alabama Alaska Arizona Arkansas California Montana Nebraska Nevada New Hampshire New Jersey New Mexico 0.9 0.003 0.006 4.5 0.0154 0.0024 0.0195 1.5364 1.7 0.580 0.7 0.2390 2.3 0.008 0.785 5.7 1.9461 0.9560 0.004 0.030 0.444 1.3 2.8 0.0096 8.7 2.970 0.1226 0.0157 35.9 12.2567 1.5705 1.9 0.006 0.649 Colorado Connecticut Delaware Florida Georgia Hawaii Idaho 4.6 0.066 New York North 19.2 6.555 3.5 0.0119 1.1949 0.029 Carolina 8.5 2.902 0.8 0.0027 0.2731 North 5.9406 17.4 0.0594 Dakota 0.6 0.002 0.205 3.926 0.0300 8.8 3.0044 Ohio 11.5 0.039 1.3 0.0044 0.4438 0.4780 4.3360 Oklahoma Oregon Pennsylvania 12.4 Rhode Island 1.1 South Carolina 3.5 0.012 1.195 1.4 0.0048 1.229 3.6 0.012 Illinois 0.042 4.234 12.7 0.0434 0.004 0.376 Indiana 0.0212 6.2 2.1168 Iowa Kansas Kentucky Louisiana Maine Maryland 3 0.0102 1.0242 0.014 4.2 1.434 2.7 0.0092 0.9218 South Dakota 0.8 0.003 0.273 0.0140 1.3998 4.1 Tennessee 5.9 0.020 2.014 4.5 0.0154 1.5364 Texas 22.5 0.077 7.682 1.3 0.0044 0.4438 Utah 0.008 0.819 2.4 5.6 0.0191 1.9119 Vermont 0.6 0.002 0.205 Massachusetts 2.1850 6.4 0.0219 Virginia 7.5 0.026 2.561 Washington 6.2 10.1 0.021 Michigan Minnesota Mississippi Missouri 0.0345 3.4483 2.117 West 5.1 0.0174 1.7412 Virginia Wisconsin Wyoming 1.8 0.006 0.615 2.9 0.0099 0.9901 5.5 0.019 1.878 5.8 0.0198 1.9802 0.171 0.5 0.002

fullscreen
Step 2

Histogram:

Step-by-step procedure to draw histogram in EXCEL:

  • Select the state and percent frequency distribution column.
  • Select Insert > Charts > Histogram.
  • For x axis, select axis option as “by category” under

The output is as follows.

8
6
4
Percent frequency distribution
Alabama
euozuy
Calilfomia
Connectiaut
epuo
llinois
lowa
Kentucky
Maine
SIDSN pessew
eosouu
Missouri
Nebraska
New Hampshire
New Mexico
North Crolina
uo 8auo
Rhodelsland
South Dakota
sexa
Vermont
Washington
Wisconsin
help_outline

Image Transcriptionclose

8 6 4 Percent frequency distribution Alabama euozuy Calilfomia Connectiaut epuo llinois lowa Kentucky Maine SIDSN pessew eosouu Missouri Nebraska New Hampshire New Mexico North Crolina uo 8auo Rhodelsland South Dakota sexa Vermont Washington Wisconsin

fullscreen
Step 3

b.

Skewness in the distribution:

From the histogram, it is observed that the mean, median, and mode of the data does not lie on the same point in ...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour*

See Solution
*Response times may vary by subject and question
Tagged in

Math

Statistics

Other

Related Statistics Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: number 10 on attached photo

A: Dependent variable of the study is the effectiveness of study strategies measured by the "number of ...

question_answer

Q: You are asked to design a study to investigate the effectiveness of the Atkins diet (IV = diet, DV =...

A: Consider the population of all individuals in a particular city. A random sample of 40 individuals i...

question_answer

Q: In a study of all 2965 professors at a college,  it is found that 45% own a computer. Determine whet...

A: It is given that 45% of professors have own computers out of 2,965 professors. 

question_answer

Q: given below are tables or formulas which might represent a discrete probability distribution. If it ...

A: a).Conditions for a discrete probability distribution:Probability value of an event should be non-ne...

question_answer

Q: Determine which score corresponds to the higher relative position by calculating the z- score for ea...

A: Calculating The standard normal variate i.e. z-score for 82 marks with mean =70 and standard deviati...

question_answer

Q: The numbers of faculty at 32 randomly selected state-controlled colleges and universities with enrol...

A: Confidence interval:The (1-α) % confidence interval for population mean µ, when σ is known is given ...

question_answer

Q: The Toylot company makes an electric train with a motor that it claims will draw an average of only ...

A: The provided information are:

question_answer

Q: Janet is studying the relationship between the average number of minutes spent exercising per day an...

A: It is given that the test score of someone who spent 23 minutes exercise is 76.98.

question_answer

Q: Question 2: The estimated regression equation for a model involving two independent variables and 65...

A: Hey, since there are multiple subparts posted, we will answer first 3 subparts. If you want any spec...