Psych 111 Statistics Journal 2
xlsx
keyboard_arrow_up
School
Brigham Young University *
*We aren’t endorsed by this school
Course
111
Subject
Statistics
Date
Jan 9, 2024
Type
xlsx
Pages
6
Uploaded by SuperHumanGiraffe808
Numbers Sheet Name
Numbers Table Name
Demonstration Data
Table 1
Mean vs. median
Table 1
Class Survey Raw Data
Table 1
Class Survey Data Cleaned
Table 1
This document was exported from Numbers.
Each table was converte
objects on each Numbers sheet were placed on separate worksheets.
calculations may differ in Excel.
Excel Worksheet Name
ed to an Excel worksheet. All other
Please be aware that formula
Demonstration Data
Mean vs. median
Class Survey Raw Data
Class Survey Data Cleaned
3
Fictional Survey of All Adult Males Working at the Yummy Stuff Bakery
Respondent #
Age
Height
Annual Income
Attitudes About Elvis
Job (1=sales 2=food prep)
1
46
80
72000
3
2
2
63
70
86000
4
1
3
63
71
89000
5
1
4
65
72
91000
2
2
5
26
80
62000
2
1
6
33
80
66000
3
2
7
51
77
80000
3
1
8
69
78
96000
5
1
9
62
78
80000
3
2
10
71
69
98000
4
1
11
24
64
55000
2
2
12
45
70
71000
2
1
13
22
72
52000
1
2
14
24
69
59000
5
1
15
23
64
55000
3
2
16
25
66
57000
2
2
17
62
75
83000
4
1
18
24
68
57000
1
2
Statistic
Mean
44.33333333333 72.38888888889 72722.22222222
3
1.5
Median
45.5
71.5
71500
3
1.5
Standard Deviation
19.01702024039 5.435600393148 15475.99870599
1.2833778958395
0.514495755427527
correlation age x height
0.324745838263
correlation age x income
0.981500173314
correlation of age x elvis
0.55675744711
t-test job type: income
t-test job type: elvis
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4
Law School Grad
Starting Salary ($)
1
190,000.00
2
156,000.00
3
201,000.00
4
170,000.00
5
168,000.00
6
2,400,000.00
7
192,000.00
8
188,000.00
9
163,000.00
10
205,000.00
11
195,000.00
12
185,000.00
Mean
367,750.00
Median
189,000.00
1
3
5
7
9
11
0
750000
1500000
2250000
3000000
Law School Grad
Starting Salary
5
Sex at birth
Height in inch Billie Eilish
Face Masks
Ice cream
Class status
Female
67
3
5 Earlier in the past
First year/ freshperson
Female
65
3
4 Earlier in the past
First year/ freshperson
Female
70
3
5 Earlier in the past
First year/ freshperson
Female
61
4
3 Earlier in the past Sophomore
Female
70
3
4 Earlier in the past
First year/ freshperson
Female
65
3
3 Earlier in the past
First year/ freshperson
Female
65
1
5 Earlier in the past
Sophomore
Female
64
3
5 Earlier in the past
Sophomore
Female
69
3
5 Earlier in the past
Junior
Female
64
3
3 Earlier in the past
First year/ freshperson
Female
67
1
3 Earlier in the past
First year/ freshperson
Female
67
1
4 Earlier in the past
First year/ freshperson
Female
70
2
4 Earlier in the past
First year/ freshperson
Female
68
3
5 Earlier in the past
First year/ freshperson
Female
67
1
3 Earlier in the past
First year/ freshperson
Female
61
2
4 Earlier in the past
First year/ freshperson
Female
64
2
3 Earlier in the past
First year/ freshperson
Female
67
1
3 Earlier in the past
First year/ freshperson
Female
65
4
4 Earlier in the past
First year/ freshperson
Female
68
3
4 Earlier in the past
First year/ freshperson
Female
65
2
4 Earlier in the past
Sophomore
Female
68
4
5 Earlier in the past
Sophomore
Female
65
2
5 Earlier in the past
Sophomore
Female
67
4
5 Earlier in the past Sophomore
Female
65
1
5 Earlier in the past
Junior
Female
68
2
4 Earlier in the past
First year/ freshperson
Female
69
2
4 Earlier in the past
First year/ freshperson
Female
63
1
4 Earlier in the past
Sophomore
Female
68
2
3 Earlier in the past
Sophomore
Female
69
2
5 Earlier in the past
First year/ freshperson
Female
66
1
4 Earlier in the past
Senior
Female
4
4 Earlier in the past
First year/ freshperson
Female
69
1
5 Earlier in the past
First year/ freshperson
Female
72.5
4
4 Earlier in the past
First year/ freshperson
Female
70
3
5 Earlier in the past
First year/ freshperson
Female
69
1
3 Earlier in the past
Junior
Female
66
1
4 Earlier in the past
First year/ freshperson
Female
55
2
4 Earlier in the past
First year/ freshperson
Female
64
2
3 Earlier in the past
Sophomore
Female
68
2
3 Today
Junior
Female
70
2
3 Earlier in the past
First year/ freshperson
Female
67
4
3 Earlier in the past
First year/ freshperson
Female
66
2
5 Earlier in the past
First year/ freshperson
Female
64
4
5 Earlier in the past
First year/ freshperson
Female
61
4
5 Earlier in the past
First year/ freshperson
Female
69
3
4 Earlier in the past
Junior
Female
66
2
4 Earlier in the past
First year/ freshperson
Female
63
1
4 Earlier in the past
First year/ freshperson
Female
63
2
4 Earlier in the past
First year/ freshperson
Female
64
5
5 Earlier in the past
First year/ freshperson
Female
66
2
5 Earlier in the past
First year/ freshperson
Female
66
2
4 Earlier in the past
First year/ freshperson
Female
64
1
5 Earlier in the past
Junior
Female
63
1
3 Earlier in the past
Sophomore
Female
67
1
3 Earlier in the past
First year/ freshperson
Female
70
1
4 Earlier in the past
First year/ freshperson
Female
64
4
4 Today
First year/ freshperson
Female
65
2
4 Earlier in the past
First year/ freshperson
Female
63
3
5 Earlier in the past
Sophomore
Female
66
3
5 Earlier in the past
Sophomore
Female
65
3
4 Earlier in the past
First year/ freshperson
Female
65
3
4 Earlier in the past
First year/ freshperson
Female
68
2
4 Earlier in the past
Sophomore
Female
67
1
4 Earlier in the past
First year/ freshperson
Female
68
4
4 Longer than that
Junior
Female
65
2
5 Earlier in the past
First year/ freshperson
Female
71
1
5 Earlier in the past
Sophomore
Female
2
5 Earlier in the past
Sophomore
Female
67
3
4 Earlier in the past
Junior
Female
63
3
4 Earlier in the past
Sophomore
Female
66
2
4 Earlier in the past
First year/ freshperson
Female
64
3
4 Earlier in the past
First year/ freshperson
Female
65
2
4 Today
Sophomore
Female
71
1
5 Today
Junior
Female
68
2
5 Earlier in the past
First year/ freshperson
Female
60
3
5 Earlier in the past
First year/ freshperson
Female
63
1
4 Earlier in the past
Sophomore
Female
67
3
5 Earlier in the past
First year/ freshperson
Female
63
1
4 Today
Sophomore
Female
64
3
4 Today
Sophomore
Female
64
2
4 Earlier in the past
First year/ freshperson
Female
67
3
5 Earlier in the past
First year/ freshperson
Female
63
1
3 Today
First year/ freshperson
Female
69
2
4 Earlier in the past
Sophomore
Female
71
4
4 Earlier in the past First year/ freshperson
Female
63
2
3 Earlier in the past
Other
Female
67
4
4 Earlier in the past
First year/ freshperson
Female
66
1
4 Earlier in the past
Junior
Female
62.5
2
4 Earlier in the past
First year/ freshperson
Female
66
2
4 Earlier in the past
First year/ freshperson
Female
63
1
4 Earlier in the past
First year/ freshperson
Female
64
1
4 Earlier in the past
First year/ freshperson
Female
70
2
3 Earlier in the past
Sophomore
Female
69
3
4 Earlier in the past
Sophomore
Female
64
2
4 Earlier in the past
First year/ freshperson
Female
66
2
4 Earlier in the past
Sophomore
Female
66
3
4 Earlier in the past
First year/ freshperson
Female
65
1
5 Earlier in the past
First year/ freshperson
Female
65
4
4 Earlier in the past
First year/ freshperson
Female
67
4
5 Earlier in the past
First year/ freshperson
Female
67
4
3 Earlier in the past
Sophomore
Female
64
3
5 Earlier in the past
Sophomore
Male
71
2
2 Earlier in the past
First year/ freshperson
Male
73
1
4 Earlier in the past
First year/ freshperson
Male
59
2
3 Earlier in the past First year/ freshperson, Junior
Male
71
1
5 Earlier in the past
Junior
Male
76
1
Earlier in the past
Sophomore
Male
70
2
2 Earlier in the past
First year/ freshperson
Male
73
1
4 Earlier in the past
First year/ freshperson
Male
71
1
5 Earlier in the past
First year/ freshperson
Male
71
1
4 Longer than that
Sophomore
Male
70
2
5 Earlier in the past
Sophomore
Male
72
2
4 Earlier in the past
First year/ freshperson
Male
71
2
5 Earlier in the past
First year/ freshperson
Male
73
2
4 Today
First year/ freshperson
Male
72
2
4 Earlier in the past
Junior
Male
69
1
5 Earlier in the past First year/ freshperson
Male
69
2
4 Earlier in the past
First year/ freshperson
Male
72
1
5 Earlier in the past Sophomore
Male
72
2
5 Earlier in the past
First year/ freshperson
Male
72
2
2 Earlier in the past
First year/ freshperson
Male
69
2
4 Today
Junior
Male
67
2
4 Earlier in the past
First year/ freshperson
Male
72
2
3 Earlier in the past
First year/ freshperson
Male
72
3
3 Earlier in the past
First year/ freshperson
Male
70
2
4 Earlier in the past
Sophomore
Male
70
2
5 Today
Junior
Male
72
2
4 Today
First year/ freshperson
Male
68
2
4 Earlier in the past
First year/ freshperson
Male
70
2
5 Longer than that
First year/ freshperson
Male
75
2
4 Earlier in the past
Sophomore
Male
73
1
3 Earlier in the past
Junior
Male
72
1
5 Earlier in the past
First year/ freshperson
Male
69
1
4 Earlier in the past
Junior
Male
69
1
5 Earlier in the past First year/ freshperson
Male
69
1
5 Earlier in the past First year/ freshperson
Male
68
2
4 Earlier in the past
First year/ freshperson
Male
72
1
3 Earlier in the past
First year/ freshperson
Male
71
2
4 Earlier in the past
Sophomore
Male
72
1
3 Earlier in the past
First year/ freshperson
Male
68
2
3 Earlier in the past
Sophomore
Male
75
1
4 Earlier in the past
Sophomore
Male
69
3
4 Earlier in the past
Sophomore
Male
69
1
5 Earlier in the past First year/ freshperson
Male
72
5
3 Earlier in the past
First year/ freshperson
Male
70
1
2 Earlier in the past
Junior
Male
70
2
4 Earlier in the past
First year/ freshperson
Male
73
1
4 Earlier in the past
First year/ freshperson, Sophomore
Male
76
1
4 Today
Sophomore
Male
70
1
4 Earlier in the past First year/ freshperson
Male
71
1
5 Earlier in the past
Senior
Male
71
1
5 Earlier in the past
Senior
Male
72
1
5 Earlier in the past
Prefer not to say
Male
74
1
5 Earlier in the past
First year/ freshperson
Male
72
1
3 Earlier in the past
First year/ freshperson
Male
73
2
4 Earlier in the past
First year/ freshperson
Male
76
2
4 Earlier in the past
Sophomore
Male
67
1
4 Earlier in the past
Sophomore
Male
72
1
5 Earlier in the past
First year/ freshperson
Male
70
1
4 Earlier in the past
Junior
Male
69
1
4 Earlier in the past
Junior
Male
77
2
3 Earlier in the past
Sophomore
Male
76
3
3 Today
Junior
Male
76
2
3 Earlier in the past
Junior
Male
71
1
5 Earlier in the past
Senior
Male
72
2
5 Earlier in the past
Sophomore
Male
73
1
4 Earlier in the past
Sophomore
Male
66
2
5 Earlier in the past
Sophomore
Male
76
1
5 Earlier in the past
Senior
Female
65.5
1
4 Earlier in the past
First year/ freshperson
Male
74
1
3 Earlier in the past
First year/ freshperson
Female
64
1
5 Earlier in the past
Sophomore
Female
62
1
5 Earlier in the past
First year/ freshperson
Female
62
2
3 Earlier in the past
Sophomore
Female
64
1
5 Earlier in the past
First year/ freshperson
Male
72
2
4 Earlier in the past
Sophomore
Female
63
3
3 Earlier in the past
First year/ freshperson
Female
66
4
5 Earlier in the past
First year/ freshperson
Female
65
4
5 Earlier in the past
Sophomore
Female
66
2
4 Earlier in the past
Junior
Female
64
2
5 Earlier in the past
First year/ freshperson
Female
69
3
5 Earlier in the past
Sophomore
Male
72
1
4 Earlier in the past
First year/ freshperson
Female
64
2
3 Earlier in the past
First year/ freshperson
Female
64
1
2 Earlier in the past
First year/ freshperson
Male
71
2
4 Earlier in the past
First year/ freshperson
Male
73
1
2 Earlier in the past
First year/ freshperson
Female
64.5
4
4 Earlier in the past
Other
Male
73
1
4 Earlier in the past
First year/ freshperson
Female
67
2
4 Earlier in the past
First year/ freshperson
Female
65
2
4 Earlier in the past
First year/ freshperson
Male
72
1
3 Earlier in the past
Sophomore
Male
67
2
5 Earlier in the past
First year/ freshperson
Male
74
4
5 Earlier in the past
First year/ freshperson
Male
74
2
3 Earlier in the past
First year/ freshperson
Female
64
3
4 Earlier in the past
Sophomore
Female
63
1
4 Earlier in the past
Sophomore
Male
73
1
5 Earlier in the past
First year/ freshperson
Female
64
3
4 Earlier in the past
Sophomore
Male
72
5
4 Today
First year/ freshperson
Female
69
2
5 Earlier in the past
First year/ freshperson
6
Sex at birth 1=female 2 =mal
Height in incheBillie Eilish 1=never list
Face Masks 1 = never weaEat ice cream 1=longer than year
5 =
Class status 1 = first year 4 = senior
1
67
3
5
4
1
1
65
3
4
4
1
1
70
3
5
4
1
1
61
4
3
2
2
1
70
3
4
4
1
1
65
3
3
4
1
1
65
1
5
4
2
1
64
3
5
4
2
1
69
3
5
3
1
64
3
3
3
1
1
67
1
3
4
1
1
67
1
4
4
1
1
70
2
4
4
1
1
68
3
5
3
1
1
67
1
3
4
1
1
61
2
4
4
1
1
64
2
3
4
1
1
67
1
3
4
1
1
65
4
4
4
1
1
68
3
4
3
1
1
65
2
4
4
2
1
68
4
5
4
2
1
65
2
5
4
2
1
67
4
5
2
2
1
65
1
5
3
3
1
68
2
4
3
1
1
69
2
4
4
1
1
63
1
4
4
2
1
68
2
3
3
2
1
69
2
5
4
1
1
66
1
4
3
4
1
4
4
4
1
1
69
1
5
4
1
1
72.5
4
4
4
1
1
70
3
5
4
1
1
69
1
3
4
3
1
66
1
4
3
1
1
55
2
4
3
1
1
64
2
3
4
2
1
68
2
3
5
3
1
70
2
3
3
1
1
67
4
3
4
1
1
66
2
5
4
1
1
64
4
5
3
1
1
61
4
5
4
1
1
69
3
4
3
3
1
66
2
4
4
1
1
63
1
4
4
1
1
63
2
4
4
1
1
64
5
5
3
1
1
66
2
5
3
1
1
66
2
4
4
1
1
64
1
5
4
3
1
63
1
3
3
2
1
67
1
3
4
1
1
70
1
4
4
1
1
64
4
4
5
1
1
65
2
4
4
1
1
63
3
5
4
2
1
66
3
5
4
2
1
65
3
4
3
1
1
65
3
4
4
1
1
68
2
4
4
2
1
67
1
4
4
1
1
68
4
4
1
3
1
65
2
5
3
1
1
71
1
5
4
2
1
2
5
4
2
1
67
3
4
4
3
1
63
3
4
4
2
1
66
2
4
4
1
1
64
3
4
3
1
1
65
2
4
5
2
1
71
1
5
5
3
1
68
2
5
3
1
1
60
3
5
3
1
1
63
1
4
4
2
1
67
3
5
4
1
1
63
1
4
5
2
1
64
3
4
5
2
1
64
2
4
4
1
1
67
3
5
4
1
1
63
1
3
5
1
1
69
2
4
3
2
1
71
4
4
2
1
1
63
2
3
4
1
67
4
4
4
1
1
66
1
4
4
3
1
62.5
2
4
4
1
1
66
2
4
4
1
1
63
1
4
4
1
1
64
1
4
4
1
1
70
2
3
4
2
1
69
3
4
4
2
1
64
2
4
4
1
1
66
2
4
3
2
1
66
3
4
4
1
1
65
1
5
3
1
1
65
4
4
3
1
1
67
4
5
3
1
1
67
4
3
4
2
1
64
3
5
3
2
2
71
2
2
4
1
2
73
1
4
3
1
2
59
2
3
2
2
71
1
5
3
3
2
76
1
3
2
2
70
2
2
4
1
2
73
1
4
3
1
2
71
1
5
3
1
2
71
1
4
1
2
2
70
2
5
4
2
2
72
2
4
3
1
2
71
2
5
3
1
2
73
2
4
5
1
2
72
2
4
4
3
2
69
1
5
2
1
2
69
2
4
3
1
2
72
1
5
2
2
2
72
2
5
3
1
2
72
2
2
4
1
2
69
2
4
5
3
2
67
2
4
4
1
2
72
2
3
4
1
2
72
3
3
3
1
2
70
2
4
3
2
2
70
2
5
5
3
2
72
2
4
5
1
2
68
2
4
4
1
2
70
2
5
1
1
2
75
2
4
3
2
2
73
1
3
4
3
2
72
1
5
4
1
2
69
1
4
4
3
2
69
1
5
2
1
2
69
1
5
2
1
2
68
2
4
4
1
2
72
1
3
4
1
2
71
2
4
4
2
2
72
1
3
4
1
2
68
2
3
3
2
2
75
1
4
4
2
2
69
3
4
4
2
2
69
1
5
2
1
2
72
5
3
3
1
2
70
1
2
3
3
2
70
2
4
4
1
2
73
1
4
4
2
76
1
4
5
2
2
70
1
4
2
1
2
71
1
5
4
4
2
71
1
5
4
4
2
72
1
5
4
2
74
1
5
4
1
2
72
1
3
4
1
2
73
2
4
4
1
2
76
2
4
4
2
2
67
1
4
4
2
2
72
1
5
4
1
2
70
1
4
3
3
2
69
1
4
4
3
2
77
2
3
4
2
2
76
3
3
5
3
2
76
2
3
4
3
2
71
1
5
4
4
2
72
2
5
4
2
2
73
1
4
4
2
2
66
2
5
4
2
2
76
1
5
3
4
1
65.5
1
4
3
1
2
74
1
3
4
1
1
64
1
5
4
2
1
62
1
5
3
1
1
62
2
3
4
2
1
64
1
5
4
1
2
72
2
4
4
2
1
63
3
3
4
1
1
66
4
5
4
1
1
65
4
5
4
2
1
66
2
4
4
3
1
64
2
5
3
1
1
69
3
5
4
2
2
72
1
4
4
1
1
64
2
3
3
1
1
64
1
2
4
1
2
71
2
4
4
1
2
73
1
2
4
1
1
64.5
4
4
4
2
73
1
4
4
1
1
67
2
4
4
1
1
65
2
4
3
1
2
72
1
3
4
2
2
67
2
5
3
1
2
74
4
5
4
1
2
74
2
3
3
1
1
64
3
4
4
2
1
63
1
4
3
2
2
73
1
5
3
1
1
64
3
4
4
2
2
72
5
4
5
1
1
69
2
5
4
1
Statistic
Mean
67.9949748743719
2.0547263681592
4.08
3.66169154228856
Median
68
2
4
4
1
Standard Deviation
3.868413251609
1.02566566177836
0.791665123863435
0.744966525676228
0.786315687596529
Correlation gender x height
0.714388648181648
Correlation gender x Billie Eili
-0.321810761645303
Correlation gender x ice cream
-0.085994730630129
Summary:
Gender and Height have a strong correlation because it is close
to 1. Males tend to be taller so the correlation is positive.
There is a negative correlation between gender and listening
to Billie Eilish. It isn’t a strong correlation being at -0.32 so
there isn’t much of a correlation between the two variables.
Gender and Ice Cream have almost no correlation. The
correlation coefficient is almost at zero. Gender doesn’t
relate to how often someone has ice cream.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Suppose you need to summarize ordinal data in a bar graph. How would you arrange the categories of data on the horizontal axis? Is it possible to make the order of the data apparent in a pie chart?
arrow_forward
Create scatterplot using Excel with the following variables:
gender: 0 = male, 1 = female.
height: in inches.
weight: in pounds.
First we will create a scatterplot to examine how weight is related to height, ignoring gender.
To do that in Excel:
Sort the data by gender:
Hold down the Control key (Command key on MacOS) and click the A key to select all of the data in the worksheet.
Select the Home tab, then the Editing group Sort & Filter -> Custom Sort.
In the pop-up window, make sure that My list has headers box is checked and then choose gender from the pull-down menu next to Sort by. Click OK.
Now select all of the data in columns B and C, select the Insert tab and in the Charts group choose Scatter.
Choose the first scatterplot option (Scatter with only Markers).
Now we have a scatterplot, but the data is all on the right of the plot. To fix this:
Right-click on the x-axis, and choose Format Axis from the pop-up menu.
Make sure that Axis Options is selected on the left, and…
arrow_forward
How does the number of attributes of a variable impact the number of cells in the cross-tabulation table and what does each cell represent?
arrow_forward
ANSWER and EXPLAIN FOR BETTER UNDERSTANDING The Following Problem USING EXCEL. Kindly ATTACH THE EXCEL FILE ON GDRIVE LINK:
https://drive.google.com/drive/folders/1GPsTMNYrbI6tyc1Gx7ehjxahvv-PeEj5?usp=sharing
arrow_forward
Please produce descriptive statistics for this data set
arrow_forward
The accompanying table gives the number of people diagnosed with AIDS in 2010 in 6 regions and the population of that region. Note that the "Rank Cases" column ranks the regions in order of the highest number of AIDS patients to the lowest number of AIDS patients; using 1 for the largest value and 6 for the smallest. Use the table to answer the following questions.
LOADING...
Click the icon to view the data table.
Find the population of the remaining regions in thousands and add them to the table.
Region
AIDS
Rank Cases
Population
Population
(thousands)
A
73,138
1
19,245,825
19,246
B
69,773
2
36,559,898
36,560
C
54,755
3
18,207,130
nothing
D
38,544
4
23,900,845
nothing
E
20,810
5
12,431,007
nothing
F
6,068
6
591,888
nothing
(Round to the nearest whole number as needed.)
arrow_forward
find 5 number summary for given data
2,5,8,9,11,15,14,16,18,20,25,30,35,40,48,50
arrow_forward
Each year Money magazine publishes a list of "Best Places to Live in the United States." These listings are based on affordability, educational performance, convenience, safety, and livability. The below table shows the median household income of Money magazine’s top city in each U.S. state for (Money magazine website).
Click on the datafile logo to reference the data.
City
Median Household Income ($)
City
Median Household Income ($)
Pelham, AL
66,772
Bozeman, MT
49,303
Juneau, AK
84,101
Papillion, NE
79,131
Paradise Valley, AZ
138,192
Sparks, NV
54,230
Fayetteville, AR
40,835
Nashua, NH
66,872
Monterey Park, CA
57,419
North Arlington, NJ
73,885
Lone Tree, CO
116,761
Rio Rancho, NM
58,982
Manchester, CT
64,828
Valley Stream, NY
88,693
Hockessin, DE
115,124
Concord, NC
54,579
St. Augustine, FL
47,748
Dickinson, ND
71,866
Vinings, GA
73,103
Wooster, OH
43,054
Kapaa, HI
62,546
Mustang, OK
66,714…
arrow_forward
Select the measurement scale in the right column that best matches the description in the left column. Note that each scale (nominal scale, ordinal
scale, interval scale, and ratio scale) will be used exactly once.
The values of data measured on this scale can be rank ordered. In addition, the
differences between two adjacent ranks are equal.
The values of data measured on this scale can be a number or a name, but they can be
rank ordered.
The values of data measured on this scale can be rank ordered and have meaningful
differences between scale points. For this scale, there is also an absolute zero point.
Data on this scale are measured by determining the category to which they belong.
arrow_forward
The data in the picture contains purchase data for golf purchases. Create a doughnut chart in Excel to compare the purchases by gender each year with the US population. Below the chart, explain what it illustrates.
arrow_forward
Use a PivotTable to construct a cross-tabulation for Marital Status and Housing Type for the data provided.
E Click the icon to view the Marital Status and Housing Type data.
Complete the cross-tabulation for Marital Status vs. Housing Type.
(Type whole numbers.)
Marital Status vs Housing Type
Count
Column Labels
Row Labels Other
Own
Rent
Grand
Total
Divorced
Married
Single
Grand Total
OOOO
OOOO
arrow_forward
In a study, researchers wanted to measure the effect of alcohol on the hippocampal region, the portion of the brain responsible for long-term memory storage, in adolescents. The researchers randomly selected 23 adolescents with
alcohol use disorders to determine whether the hippocampal volumes in the alcoholic adolescents were less than the normal volume of 9.02 cm. An analysis of the sample data revealed that the hippocampal volume is
approximately normal with no outliers and x 8.18 cm and s=0.8 cm. Conduct the appropriate test at the a= 0.01 level of significance.
State the null and alternative hypotheses.
Ho: H
H1:
(Type integers or decimals. Do not round.)
Identify the t-statistic.
to = (Round to two decimal places as needed.)
!!
Identify the P-value.
P-value = (Round to three decimal places as needed.)
Make a conclusion regarding the hypothesis.
the null hypothesis. There
sufficient evidence to claim that the mean hippocampal volume is
cm³
Statcrunch
Next
8:01
SAMSUNG
esc
@
%23
$…
arrow_forward
Please check answers
1; 0.351
2; 0.060
3;0.205
4; 0.172
arrow_forward
Suppose you have information about average heights of a random sample ofairplane passengers. The mode is 70 inches, the median is 68 inches, and themean is 71 inches. To convert the data into centimeters, multiply each datavalue by 2.54. What are the values of the mode, median, and mean incentimeters?
arrow_forward
A box and whisker plots show what data?
arrow_forward
List an advatge of microdata, and of aggregated data
Answer in a few sentences thank you.
arrow_forward
Please help asap with this. thank you!
arrow_forward
Please correct my answers for b and c with explanation. Need to understand for exam, thanks!
arrow_forward
A store manager kept track of the number of newspapers sold each week over an 8-week period. The results were as follows: 0, 88, 71, 201, 113, 269, 248, 250.
Find the 5 number summary for the data. Is the data discrete or continious?
arrow_forward
Make a two-way table from the accompanying table, for gender and eye color. Put the labels Male and Female on the top and the labels Brown, Blue, and Hazel on the side, and then tally the data. Complete parts (a) through (f) below.
LOADING...
Click the icon to view the data table.
Question content area bottom
Part 1
a. Arrange the data as a two-way table and report how many students are in each cell. For each cell, make a tally mark using the capital letter I for each person who has both of the characteristics belonging to that cell. Type a 0 if there are no students with the given characteristics.
Male
Female
Total
Brown
enter your response here
enter your response here
Blue
enter your response here
enter your response here
Hazel
enter your response here
enter your response here
Total
Part 2
b. Sum the numbers of students in each row and each column, and put these sums…
arrow_forward
how do you determine how many observations are in the first class of a stem and leaf chart
arrow_forward
Please answer in detail
arrow_forward
The table summarizes results from pedestrian deaths that were caused by automobile accidents.
Pedestrian Deaths
Driver
Pedestrian Intoxicated?
Intoxicated?
Yes
No
Yes
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Elementary Geometry For College Students, 7e
Geometry
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Cengage,
Related Questions
- Suppose you need to summarize ordinal data in a bar graph. How would you arrange the categories of data on the horizontal axis? Is it possible to make the order of the data apparent in a pie chart?arrow_forwardCreate scatterplot using Excel with the following variables: gender: 0 = male, 1 = female. height: in inches. weight: in pounds. First we will create a scatterplot to examine how weight is related to height, ignoring gender. To do that in Excel: Sort the data by gender: Hold down the Control key (Command key on MacOS) and click the A key to select all of the data in the worksheet. Select the Home tab, then the Editing group Sort & Filter -> Custom Sort. In the pop-up window, make sure that My list has headers box is checked and then choose gender from the pull-down menu next to Sort by. Click OK. Now select all of the data in columns B and C, select the Insert tab and in the Charts group choose Scatter. Choose the first scatterplot option (Scatter with only Markers). Now we have a scatterplot, but the data is all on the right of the plot. To fix this: Right-click on the x-axis, and choose Format Axis from the pop-up menu. Make sure that Axis Options is selected on the left, and…arrow_forwardHow does the number of attributes of a variable impact the number of cells in the cross-tabulation table and what does each cell represent?arrow_forward
- ANSWER and EXPLAIN FOR BETTER UNDERSTANDING The Following Problem USING EXCEL. Kindly ATTACH THE EXCEL FILE ON GDRIVE LINK: https://drive.google.com/drive/folders/1GPsTMNYrbI6tyc1Gx7ehjxahvv-PeEj5?usp=sharingarrow_forwardPlease produce descriptive statistics for this data setarrow_forwardThe accompanying table gives the number of people diagnosed with AIDS in 2010 in 6 regions and the population of that region. Note that the "Rank Cases" column ranks the regions in order of the highest number of AIDS patients to the lowest number of AIDS patients; using 1 for the largest value and 6 for the smallest. Use the table to answer the following questions. LOADING... Click the icon to view the data table. Find the population of the remaining regions in thousands and add them to the table. Region AIDS Rank Cases Population Population (thousands) A 73,138 1 19,245,825 19,246 B 69,773 2 36,559,898 36,560 C 54,755 3 18,207,130 nothing D 38,544 4 23,900,845 nothing E 20,810 5 12,431,007 nothing F 6,068 6 591,888 nothing (Round to the nearest whole number as needed.)arrow_forward
- find 5 number summary for given data 2,5,8,9,11,15,14,16,18,20,25,30,35,40,48,50arrow_forwardEach year Money magazine publishes a list of "Best Places to Live in the United States." These listings are based on affordability, educational performance, convenience, safety, and livability. The below table shows the median household income of Money magazine’s top city in each U.S. state for (Money magazine website). Click on the datafile logo to reference the data. City Median Household Income ($) City Median Household Income ($) Pelham, AL 66,772 Bozeman, MT 49,303 Juneau, AK 84,101 Papillion, NE 79,131 Paradise Valley, AZ 138,192 Sparks, NV 54,230 Fayetteville, AR 40,835 Nashua, NH 66,872 Monterey Park, CA 57,419 North Arlington, NJ 73,885 Lone Tree, CO 116,761 Rio Rancho, NM 58,982 Manchester, CT 64,828 Valley Stream, NY 88,693 Hockessin, DE 115,124 Concord, NC 54,579 St. Augustine, FL 47,748 Dickinson, ND 71,866 Vinings, GA 73,103 Wooster, OH 43,054 Kapaa, HI 62,546 Mustang, OK 66,714…arrow_forwardSelect the measurement scale in the right column that best matches the description in the left column. Note that each scale (nominal scale, ordinal scale, interval scale, and ratio scale) will be used exactly once. The values of data measured on this scale can be rank ordered. In addition, the differences between two adjacent ranks are equal. The values of data measured on this scale can be a number or a name, but they can be rank ordered. The values of data measured on this scale can be rank ordered and have meaningful differences between scale points. For this scale, there is also an absolute zero point. Data on this scale are measured by determining the category to which they belong.arrow_forward
- The data in the picture contains purchase data for golf purchases. Create a doughnut chart in Excel to compare the purchases by gender each year with the US population. Below the chart, explain what it illustrates.arrow_forwardUse a PivotTable to construct a cross-tabulation for Marital Status and Housing Type for the data provided. E Click the icon to view the Marital Status and Housing Type data. Complete the cross-tabulation for Marital Status vs. Housing Type. (Type whole numbers.) Marital Status vs Housing Type Count Column Labels Row Labels Other Own Rent Grand Total Divorced Married Single Grand Total OOOO OOOOarrow_forwardIn a study, researchers wanted to measure the effect of alcohol on the hippocampal region, the portion of the brain responsible for long-term memory storage, in adolescents. The researchers randomly selected 23 adolescents with alcohol use disorders to determine whether the hippocampal volumes in the alcoholic adolescents were less than the normal volume of 9.02 cm. An analysis of the sample data revealed that the hippocampal volume is approximately normal with no outliers and x 8.18 cm and s=0.8 cm. Conduct the appropriate test at the a= 0.01 level of significance. State the null and alternative hypotheses. Ho: H H1: (Type integers or decimals. Do not round.) Identify the t-statistic. to = (Round to two decimal places as needed.) !! Identify the P-value. P-value = (Round to three decimal places as needed.) Make a conclusion regarding the hypothesis. the null hypothesis. There sufficient evidence to claim that the mean hippocampal volume is cm³ Statcrunch Next 8:01 SAMSUNG esc @ %23 $…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Elementary Geometry For College Students, 7eGeometryISBN:9781337614085Author:Alexander, Daniel C.; Koeberlein, Geralyn M.Publisher:Cengage,
Elementary Geometry For College Students, 7e
Geometry
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Cengage,