Data Analysis Assignment for HLST 2300 Students

Calculating Mean and Standard Deviation

 An instructor has collected data for 147 HLST 2300 students (Excel file: 2300FTassignment1.xls). The data includes the unique student identifier (ID) and the responses to the following survey questions: Q1: Are you currently working at a job for pay? (0 = no; 1 = yes) Q2: What is your favourite colour? (1 = blue; 2 = green; 3 = orange; 4 = purple; 5 = red; 6 = yellow; 7 = none of the above) Q3: How would you rate remote learning so far? (1 = very poor; 2 = poor; 3 = fair; 4 = good; 5 = very good; 6 = excellent; 7 = cannot say) Q4: How much time, on average, do you spend on social media a day? (1 = <1hr; 2 = ?1hr but <2hr; 3 = ?2hr but <3hr; 4 = ?3hr) Q5: Did you enter the SHPM program directly from high school? (0 = no; 1 = yes) Q6: What program are you currently enrolled in? (1 = General Honours BHS; 2 = Specialized Hons BHS – Informatics; 3 = Specialized Hons BHS – Management; 4 = Specialized Hons BHS – Policy; 5 = none of the above) Q7: How many hours did you spend on zoom last week? (note this variable – which is to one decimal place - didn’t come from our Zoom survey; I made it up) a. Using pen and paper, calculate the mean and sample standard deviation of hours spent on zoom last week (Q7) using data from the first 5 respondents (Respondent_ID 1 through 5) (n=5). SHOW YOUR WORK. b. In a sentence, describe what the sample standard deviation you calculated in part a) means. c. Using pen and paper, calculate median and IQR of hours spent on zoom last week (Q7) using data from the first 10 respondents (Respondent_ID 1 through 10). SHOW YOUR WORK. d. Using pen and paper, draw a boxplot of hours spend on zoom last week (Q7) using data from the first 10 respondents (Respondent_ID 1 through 10), clearly identifying the values of Q1, Q2, Q3, adjacent scores, outlier territory, and extreme value territory. SHOW YOUR WORK for how you calculated the outlier territory and extreme value territory. e. Using pen and paper, calculate median and IQR of hours spent on zoom last week (Q7) using data from the first 11 respondents (Respondent_ID 1 through 11). SHOW YOUR WORK. f. Generate a pivot table that includes the observed counts of favourite colour (Q2) (placed as rows) by high school entry (Q5) (placed as columns), layered by current program of enrollment (Q6). Copy and paste the generated pivot table and highlight/place a box around the answer to the following question: How many General Honours BHS respondents who did not enter SHPM directly from high school had green as their favourite colour? g. Generate a frequency table for Q3. Copy and paste the generated frequency table and answer the following questions: i. What percent of respondents rated remote learning as fair? Highlight/place a box around the answer. ii. What percent of respondents rated remote learning as fair or worse? Using the cumulative percent column, highlight/place a box around the answer. iii. What percent of respondents rated remote learning worse than fair? Using the cumulative percent column, highlight/place a box around the answer. h. Among the Specialized Hons BHS – Management students, what is the mean and standard deviation hours spent on zoom last week (Q7)? Copy and paste the generated SPSS output table and highlight/place a box around the answers. i. Among respondents who are currently working at a job for pay, what is the 90th percentile of hours spent on zoom last week? Copy and paste the generated SPSS output table and highlight/place a box around the answer. j. In a sentence, describe what the 90th percentile generated in part i) means and relate it to the remaining 10%. k. Generate a boxplot graph of hours spent on zoom last week (Q7) which contains the boxplots for the five programs (Gen Hons, Spec Man, Spec. Pol, Spec. Inf, none of the above) side-by-side. Copy and paste the generated SPSS boxplot graph and place a box around the boxplot of the program that has the smallest median hours spent on zoom last week. l. Using the boxplot graph generated in part k), in a sentence, describe what the values ‘105’ and ‘55’ identified in the boxplot represent. m. Create a new variable, ‘Q7_bin2hr’ that is a binned variable of Q7 with bin width = 2hr (upper endpoints included). Generate a frequency table of this new binned variable. Copy and paste the generated SPSS frequency table and using values in the cumulative percent column, calculate the answer to the following question: What percent of respondents spent more than 14 hrs on zoom last week? SHOW YOUR WORK. n. Generate a percent histogram of Q7_bin2hr (the new variable you created in part m). Display the percentages (round to 1 decimal place with the % symbol removed) in each bar to add clarity. Be sure that there are no spaces between bars. Copy and paste the generated SPSS histogram. Highlight/place a box around the mode. o. Using the percent histogram generated in part n), in a sentence, describe what the mode means – be sure to describe it in terms of the x-axis.