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
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
Please use typing and answer all questions as from one subpart.
arrow_forward
Explain the concept of Notation for Panel Data?
arrow_forward
You've heard of "Florida Man;" now meet "Florida Bear." This problem involves data from a
subspecies of black bear found in Florida, Ursus americanus floridanus. The data were collected by T. D.
Bartareau as part of a study published in the Journal of Fish and Wildlife Management (2017, vol 8, pp 234-
239). Before you begin consult the info sheet included at the end
(a) Do you predict an allometric or isometric scaling relationship between body weight and body length?
Explain.
(b) Based on your answer to part a, what would a plot of log body weight (vertical axis) versus log body length
(horizontal axis) look like?
(c) Using the data provided, create a plot of log body weight versus log body length. Make sure to label the
axes. Why might someone think your plot fails to provide clear support for your claim in part b?
(d) Using the tools described on the info sheet to isolate portions of the dataset, refine your use of data in part
c to strengthen support for your claim in b. Why does…
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
IQR for data set
41, 49, 55, 82, 84, 85, 93, 103, 113, 121, 126, 127, 136, 136, 155, 166, 169, 178, 193, 204, 445
arrow_forward
The U.S. Census Bureau collects data on household size and publishes the information in Current Population Reports. What kind of data is the number of people in your household?
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
Here is a set of 20 values in order:
1, 2, 5, 10, 11, 12, 14, 15, 15, 16, 18, 19, 20, 21, 22, 24, 25, 28, 32, 45
Do not use software for this question. Using your pencil, paper, and perhaps your calculator, determine the values for the 5 Number Summary for this set of data and type your answer into the essay text box.
arrow_forward
Need help on letters A-G (all questions). Thank you.
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
the data file is just a blank excel sheet, you do not need to see it to access information.
arrow_forward
When the data is organised in a table, the rows are (circle the answer);(a) variables (b) numbers (c) categories (d) cases
arrow_forward
how does the number of attributes of a variable impact the number of cells in the cross-tabulation table and describe what each cell represents?
arrow_forward
Please help with (d)
arrow_forward
Please explain all work, including use of excel.
arrow_forward
Please do not give solution in image formate thanku.
arrow_forward
Enter the data in SPSS or EXCEL
Merge the two data sets
Once you have entered all the data, create a table to display the information
Use any graphical method to present the data
Comment on the findings
Country
May
June
July
August
Sept
October
Uganda
947
57
63
117
37
90
Kenya
411
42
55
100
85
49
Tanzania
521
72
02
116
52
46
Rwanda
753
55
15
89
4
14
Burundi
964
52
1
122
70
33
Ethiopia
327
6
26
135
17
24
Congo
967
6
7
113
90
53
Somalia
670
21
5
24
28
75
Eritrea
379
28
3
16
39
85
Country
May
June
July
August
Sept.
Oct.
Sudan
39
5
38
11
82
86
Chad
44
10
93
11
101
187
Mali
25
30
67
21
132
82
Benin
47
37
44
10
44
21
Togo
49
31
116
11
31
18
Niger
23
40
37
13
88
18
Gambia
39
49
90
21
130
139…
arrow_forward
Do histograms have to show grouped data? Can
you use them for individual numbers as well as groups of
numbers?
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
Please show me how this is worked out
arrow_forward
What Is Control Charts for Attributes?
arrow_forward
There are no hard-and-fast rules in determining how to develop a questionnaire. Fortunately, research experience has yielded some guidelines that help prevent the most common mistakes. The language should be simple to allow for variations in educational level. There are six critical and common mistakes researchers make when determining wording of each questions. Describe each of them and provide an example question to each of the common mistake.
arrow_forward
The price per share of stock for a sample of 25 companies was recorded at the beginning of the first financial quarter and then again at the end of the first financial quarter. How stocks perform during the first
quarter is an indicator of what is ahead for the stock market and the economy. Use the sample data in the file StockQuarter to answer the following.
Click on the datafile logo to reference the data.
DATA file
a. Let di denote the percentage change in price per share for company i where
7.46
Confidence interval
Interpret this result.
The stock market experiences a decline
Company
Bank of New York Mellon
Kraft Foods
E.I. du Pont de Nemours and Company
Consolidated Edison
) (to 3 decimals)
Johnson & Johnson
Union Pacific
Comcast
Applied Materials.
Pfizer
General Electric
AT&T
Cisco Systems
Home Depot
✔
JP Morgan Chase
Procter & Gamble
Verizon
Devon Energy
Lilly
Microsoft
Coca Cola
Qualcomm
Exxon Mobil Corporation
PG&E Corporation
Oracle Corporation
Chevron
end of 1st quarter…
arrow_forward
Find the 5 number summary of the following set of data: 11, 8, 12, 4, 7, 10, 3, 15, 8, 8, 7
arrow_forward
FOLLOW THE INSTRUCTIONS
TYPEWRITTEN ONLY PLEASE FOR UPVOTE. DOWNVOTE FOR HANDWRITTEN. DO NOT ANSWER IF YOU ALREADY ANSWERED THIS
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
The Acme School of Locksmiths has been accredited for the past 15 years. Discuss how this information might be interpreted as a
a. qualitative variable
b. quantitative variable
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_forwardPlease use typing and answer all questions as from one subpart.arrow_forward
- Explain the concept of Notation for Panel Data?arrow_forwardYou've heard of "Florida Man;" now meet "Florida Bear." This problem involves data from a subspecies of black bear found in Florida, Ursus americanus floridanus. The data were collected by T. D. Bartareau as part of a study published in the Journal of Fish and Wildlife Management (2017, vol 8, pp 234- 239). Before you begin consult the info sheet included at the end (a) Do you predict an allometric or isometric scaling relationship between body weight and body length? Explain. (b) Based on your answer to part a, what would a plot of log body weight (vertical axis) versus log body length (horizontal axis) look like? (c) Using the data provided, create a plot of log body weight versus log body length. Make sure to label the axes. Why might someone think your plot fails to provide clear support for your claim in part b? (d) Using the tools described on the info sheet to isolate portions of the dataset, refine your use of data in part c to strengthen support for your claim in b. Why does…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_forwardIQR for data set 41, 49, 55, 82, 84, 85, 93, 103, 113, 121, 126, 127, 136, 136, 155, 166, 169, 178, 193, 204, 445arrow_forwardThe U.S. Census Bureau collects data on household size and publishes the information in Current Population Reports. What kind of data is the number of people in your household?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_forwardfind 5 number summary for given data 2,5,8,9,11,15,14,16,18,20,25,30,35,40,48,50arrow_forwardHere is a set of 20 values in order: 1, 2, 5, 10, 11, 12, 14, 15, 15, 16, 18, 19, 20, 21, 22, 24, 25, 28, 32, 45 Do not use software for this question. Using your pencil, paper, and perhaps your calculator, determine the values for the 5 Number Summary for this set of data and type your answer into the essay text box.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,