Filename: Pennstate2 Extension: .txt Summary: Data from n=205 students in a statistics class for students in the social and behavioral sciences. The survey was done in the Spring semester of...

1 answer below ยป





Filename: Pennstate2 Extension: .txt Summary: Data from n=205 students in a statistics class for students in the social and behavioral sciences. The survey was done in the Spring semester of 2000. (Source: Mind on Statistics (Utts and Heckard)) The dataset has been modified for this homework. Variable Names in order from left to right: Column Name Description A Gender Male or Female B Tattoo Does student have a tattoo (Yes or No) C CDs Categorized number of the student's estimate of how many music CDs he/she owns (BelowAvg = 0 to 30, Average = 31 to 80, AboveAvg = more than 80) D Height Self-reported height in inches E EarPrc Number of ear piercings


Classify the variables


1. Create a table of variable definitions for all of the variables in the Pennstate2 data file.






Univariate descriptive statistics and visualizations


2. For each qualitative variable: a) provide a table containing the frequency, relative frequency, cumulative frequency, and totals, b) generate a bar chart and a pie chart, and c) discuss one frequency and one relative frequency in the context of the variable.






3. Observe the pie chart and bar chart for an ordinal variable. Which is a better visualization of the variable? Explain. [You should only complete this exercise if there is an ordinal variable in the data set.]






4. For each quantitative variable: a) use the Descriptive Statistics analysis tool to generate a table of descriptive statistics (including the margin of error for the 95% confidence interval), b) generate a box plot and a histogram (with bin frequencies), c) identify the shape of the distribution, and d) comment on the most appropriate measure of central tendency and the most appropriate measure of dispersion and interpret the associated values in the context of the variable.


2


Dr. Kimberly Gardner 2019 Assessment 1






Multivariate descriptive statistics and visualizations


5. Stratify the variable
EarPrc
by the variable
Tattoo. Complete the following: a) make a table of the descriptive statistics for each group and include the margin of error for the 95% confidence interval, b) generate a side by side box-whiskers plot, c) interpret the 95% confidence interval for each group, and discuss whether there is evidence the means are statistically significant.






6. Select a reasonable variable for stratifying the variable
Height,
and explain your selection. Complete the following: a) make a table of the descriptive statistics for each group and include the margin of error for the 95% confidence interval b) generate side by side box-whiskers plots, c) interpret the 95% confidence interval for each group, and discuss whether there is evidence the means are statistically significant.






7. Generate a contingency table for
Gender
by
CDs. Provide the following: a) a frequency table, b) a relative frequency table, c) row frequencies table, d) column frequencies table, e) an interpretation of the value in the second row, first column of each table in the context of the data.






8. Generate a stacked bar chart and a 100% stacked bar chart for the row frequencies of
Gender
by
CDs. Provide the following: a) a description of the differences between the graphics, b) determine which graph is a better visualization or the relationship between the variables and why.






Random number generation and simple random sampling


9. Generate a simple random sample of 45 observations using the RAND function. Display your sample with the sorted random numbers in the table. Generate the descriptive statistics for ONE quantitative variable and ONE qualitative variable. Comment on how the statistics compare to those of the overall data.







Follow the guidelines provided on the course D2L page for preparing and submitting your paper. Points will be deducted for not following instructions and for unscholarly papers

Answered Same DaySep 24, 2021

Answer To: Filename: Pennstate2 Extension: .txt Summary: Data from n=205 students in a statistics class for...

Pritam answered on Sep 24 2021
148 Votes
Untitled Spreadsheet
Worksheet
    Student    Gender    Tattoo    CDs    Height    EarPrc        Row Labels    Count of Gender                            Height    EarPrc
    S2K001    Female    No    BelowAvg    70    2        Female    137
    S2K002    Male    No    BelowAvg    77    0        Male    68                        Mean    67.0280487805    2.7609756098
    S2K003    Male    No    Average    71    2        Grand Total    205                        Standard Error    0.2651845418    0.1696261259
    S2K004    Female    No    Average    65    2                                    Median    67    2
    S2K005    Male    Yes    Average    74    4        Row Labels    Count of Tattoo                        Mode    67    0
    S2K006    Female    Yes    Average    61    9        No    174                        Standard Deviation    3.7968648183    2.4286765185
    S2K007    Male    No    AboveAvg    76    0        Yes    31                        Sample Variance    14.4161824486    5.8984696318
    S2K008    Male    No    AboveAvg    73    0        Grand Total    205                        Kurtosis    -0.5182195666    0.6071971408
    S2K009    Female    No    Average    65    6                                    Skewness    0.3566784815    0.761137505
    S2K010    Female    No    Be
lowAvg    63    4        Row Labels    Count of CDs                        Range    17    13
    S2K011    Female    No    Average    64    3        AboveAvg    58                        Minimum    60    0
    S2K012    Female    No    Average    67    4        Average    70                        Maximum    77    13
    S2K013    Male    Yes    BelowAvg    70    1        BelowAvg    77                        Sum    13740.75    566
    S2K014    Male    No    Average    74    0        Grand Total    205                        Count    205    205
    S2K015    Female    No    BelowAvg    67    2                                    Confidence Level(95.0%)    0.5228539896    0.3344451983
    S2K016    Male    No    AboveAvg    71    0        Row Labels    Sum of EarPrc
    S2K017    Male    No    BelowAvg    74    0        No    444
    S2K018    Female    No    BelowAvg    64.5    5        Yes    122
    S2K019    Male    Yes    AboveAvg    73    0        Grand Total    566
    S2K020    Male    No    AboveAvg    68    0
    S2K021    Female    Yes    BelowAvg    69.5    2
    S2K022    Male    Yes    Average    71    2
    S2K023    Female    No    Average    67    2
    S2K024    Male    No    Average    71    3
    S2K025    Male    No    AboveAvg    74    0
    S2K026    Male    No    BelowAvg    69    0
    S2K027    Female    No    BelowAvg    65    4
    S2K028    Female    No    BelowAvg    66    9        Gender    Frequency    Relative Frequency    Cumulative Frequency
    S2K029    Female    No    Average    66    0        Female    137.00    0.67    0.67
    S2K030    Female    No    Average    66    2        Male    68.00    0.33    1.00
    S2K031    Female    No    BelowAvg    67    0        Total    205
    S2K032    Female    No    BelowAvg    65    4
    S2K033    Female    No    Average    64    4        Tattoo    Frequency    Relative Frequency    Cumulative Frequency
    S2K034    Male    No    Average    72    0        No    174.00    0.85    0.85
    S2K035    Male    No    Average    74    0        Yes    31.00    0.15    1.00
    S2K036    Female    No    Average    67    4        Total    205
    S2K037    Male    No    Average    73    0
    S2K038    Female    No    BelowAvg    62    4        CDs    Frequency    Relative Frequency    Cumulative Frequency
    S2K039    Male    No    BelowAvg    70    0        AboveAvg    58.00    0.28    0.28
    S2K040    Female    No    BelowAvg    60    2        Average    70.00    0.34    0.62
    S2K041    Male    No    Average    69    0        BelowAvg    77.00    0.38    1.00
    S2K042    Male    No    Average    74    0        Total    205
    S2K043    Female    No    AboveAvg    62    5
    S2K044    Female    No    BelowAvg    65    4
    S2K045    Male    No    AboveAvg    68    1
    S2K046    Female    No    Average    66    4
    S2K047    Female    No    AboveAvg    64    4
    S2K048    Female    No    Average    67    2
    S2K049    Female    Yes    AboveAvg    69    5
    S2K050    Female    No    AboveAvg    66    8
    S2K051    Female    No    BelowAvg    64    2
    S2K052    Female    No    BelowAvg    64    4
    S2K053    Female    No    Average    69    8
    S2K054    Male    No    Average    67    0
    S2K055    Female    No    BelowAvg    66    2
    S2K056    Male    No    AboveAvg    71    0
    S2K057    Female    No    Average    68    2
    S2K058    Female    No    AboveAvg    63    4
    S2K059    Female    No    BelowAvg    65    5
    S2K060    Female    No    BelowAvg    66    2
    S2K061    Female    No    BelowAvg    63    4
    S2K062    Male    No    Average    70    2
    S2K063    Female    No    BelowAvg    65    2
    S2K064    Female    No    AboveAvg    64    5
    S2K065    Female    No    Average    64    2
    S2K066    Female    No    AboveAvg    65    5
    S2K067    Female    Yes    BelowAvg    67    5
    S2K068    Female    No    BelowAvg    61    2
    S2K069    Male    No    Average    69    0
    S2K070    Male    Yes    BelowAvg    70    2
    S2K071    Female    No    BelowAvg    67    4
    S2K072    Female    No    AboveAvg    64    2
    S2K073    Female    No    AboveAvg    63    4
    S2K074    Male    No    AboveAvg    70    0
    S2K075    Female    No    AboveAvg    63    4
    S2K076    Male    No    AboveAvg    69    0
    S2K077    Female    No    Average    64    4
    S2K078    Female    No    BelowAvg    67    2
    S2K079    Male    Yes    Average    75    0
    S2K080    Male    Yes    AboveAvg    70    0
    S2K081    Female    No    AboveAvg    65    2
    S2K082    Male    No    BelowAvg    66    0
    S2K083    Male    Yes    AboveAvg    74    2
    S2K084    Female    No    BelowAvg    64    6
    S2K085    Female    No    Average    63    5
    S2K086    Female    No    AboveAvg    63    4
    S2K087    Female    No    BelowAvg    63    5
    S2K088    Male    No    Average    70    0
    S2K089    Female    No    BelowAvg    67    5
    S2K090    Female    No    BelowAvg    66    2
    S2K091    Female    No    Average    67    2
    S2K092    Female    No    BelowAvg    65    6
    S2K093    Female    No    AboveAvg    67    2
    S2K094    Female    Yes    Average    67    7
    S2K095    Female    No    Average    67    4
    S2K096    Female    No    BelowAvg    62.5    6
    S2K097    Female    No    Average    67    2
    S2K098    Female    Yes    Average    68    8
    S2K099    Female    No    Average    66    2
    S2K100    Male    No    AboveAvg    68    0
    S2K101    Female    Yes    BelowAvg    67    6
    S2K102    Female    Yes    AboveAvg    64    7
    S2K103    Female    No    BelowAvg    62    2
    S2K104    Male    No    AboveAvg    74    0
    S2K105    Male    No    AboveAvg    71    0
    S2K106    Female    No    BelowAvg    65    4
    S2K107    Female    No    BelowAvg    63    2
    S2K108    Male    No    AboveAvg    74    0
    S2K109    Male    No    AboveAvg    72    0
    S2K110    Female    No    AboveAvg    63    0
    S2K111    Male    Yes    AboveAvg    69    1
    S2K112    Female    No    Average    60    8
    S2K113    Female    No    AboveAvg    60    6
    S2K114    Female    No    BelowAvg    67    5
    S2K115    Male    No    BelowAvg    71    0
    S2K116    Female    No    BelowAvg    64    5
    S2K117    Male    No    AboveAvg    71    0
    S2K118    Male    No    Average    71    0
    S2K119    Female    No    BelowAvg    65    2
    S2K120    Female    No    AboveAvg    64    5
    S2K121    Female    No    BelowAvg    61    4
    S2K122    Male    Yes    Average    72    3
    S2K123    Female    Yes    Average    66    5
    S2K124    Male    No    Average    72    0
    S2K125    Female    Yes    Average    61    5
    S2K126    Female    No    AboveAvg    66    13
    S2K127    Female    No    Average    64.75    2
    S2K128    Female    No    BelowAvg    65    2
    S2K129    Male    No    AboveAvg    67    0
    S2K130    Male    No    Average    72    0
    S2K131    Male    No    Average    67    0
    S2K132    Female    Yes    Average    64    4
    S2K133    Female    No    BelowAvg    65    2
    S2K134    Female    No    Average    63    7
    S2K135    Male    No    AboveAvg    74    0
    S2K136    Female    No    BelowAvg    70    4
    S2K137    Female    No    Average    65    6
    S2K138    Female    No    BelowAvg    66    4
    S2K139    Female    No    BelowAvg    65    2
    S2K140    Male    No    AboveAvg    68    0
    S2K141    Female    No    AboveAvg    69    4
    S2K142    Female    No    Average    64    2
    S2K143    Female    No    Average    65    4
    S2K144    Male    No    BelowAvg    69    0
    S2K145    Female    No    Average    61    5
    S2K146    Female    No    BelowAvg    63    7
    S2K147    Male    No    BelowAvg    70    0
    S2K148    Female    No    BelowAvg    65    3
    S2K149    Female    No    Average    68    2
    S2K150    Female    No    AboveAvg    64    0
    S2K151    Female    No    Average    65    2
    S2K152    Female    No    BelowAvg    67    2
    S2K153    Female    No    BelowAvg    66    2
    S2K154    Female    Yes    AboveAvg    66    3
    S2K155    Female    No    AboveAvg    71    4
    S2K156    Female    No    AboveAvg    66    2
    S2K157    Female    Yes    AboveAvg    61    4
    S2K158    Female    No    Average    67    7
    S2K159    Female    No    AboveAvg    66    4
    S2K160    Male    No    BelowAvg    76    0
    S2K161    Female    Yes    BelowAvg    63    6
    S2K162    Male    Yes    Average    72    2
    S2K163    Female    Yes    AboveAvg    60    3
    S2K164    Male    No    AboveAvg    70    0
    S2K165    Female    No    BelowAvg    66    4
    S2K166    Male    No    BelowAvg    72    1
    S2K167    Female    No    AboveAvg    62    2
    S2K168    Female    Yes    Average    62.5    7
    S2K169    Male    No    BelowAvg    69    0
    S2K170    Female    No    Average    63    2
    S2K171    Female    No    Average    66    0
    S2K172    Female    No    AboveAvg    67    2
    S2K173    Female    Yes    BelowAvg    71    8
    S2K174    Male    No    BelowAvg    70    0
    S2K175    Female    No    Average    70    3
    S2K176    Female    No    BelowAvg    63    5
    S2K177    Female    No    AboveAvg    65    5
    S2K178    Female    No    BelowAvg    65    2
    S2K179    Female    No    BelowAvg    65    4
    S2K180    Female    No    BelowAvg    62    6
    S2K181    Male    No    BelowAvg    73    0
    S2K182    Female    Yes    BelowAvg    68    6
    S2K183    Female    No    BelowAvg    63    6
    S2K184    Male    Yes    AboveAvg    70    5
    S2K185    Female    No    AboveAvg    66    2
    S2K186    Female    No    Average    66    3
    S2K187    Female    No    BelowAvg    62    3
    S2K188    Female    No    Average    72    6
    S2K189    Female    No    BelowAvg    67    2
    S2K190    Female    No    AboveAvg    61    0
    S2K191    Female    No    Average    63    4
    S2K192    Female    No    BelowAvg    61    2
    S2K193    Male    No    AboveAvg    68    0
    S2K194    Female    No    Average    60    2
    S2K195    Male    No    Average    72    0
    S2K196    Female    No    BelowAvg    70    2
    S2K197    Male    No    AboveAvg    66    2
    S2K198    Male    Yes    AboveAvg    72    0
    S2K199    Female    No    Average    66    4
    S2K200    Male    No    BelowAvg    75    0
    S2K201    Female    No    BelowAvg    68    6
    S2K202    Male    No    Average    71    4
    S2K203    Male    No    Average    70    0
    S2K204    Male    No    BelowAvg    69    0
    S2K205    Female    No    Average    64    5
Total    
Female    Male    137    68    
Total    
No    Yes    174    31    
Total    
AboveAvg    Average    BelowAvg    58    70    77    
Total    
Female    Male    137    68    
Total    
No    Yes    174    31    
Total    
AboveAvg    Average    BelowAvg    58    70    77    
Sheet1
    Student    Gender    Tattoo    CDs    Height    EarPrc        Row Labels    Count of CDs
    S2K001    Female    No    BelowAvg    70    2        AboveAvg    58
    S2K002    Male    No    BelowAvg    77    0        Female    31
    S2K003    Male    No    Average    71    2        Male    27        Above average    relative freq    Average    relative freq    Below average    relative...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here