A dataset similar to section 5 of the assignment page

This preview shows page 9 - 12 out of 32 pages.

A dataset similar to section 5 of the assignment page 2 of 2 More summaries of the previous data set is Row Labels Average of daily customers StdDev of daily customers Count of daily customers KFC in the middle of the city 1402.7 253.1697059 10 KFC near the Beach 2390.2 1514.684844 10 Grand Total 1896.45 1172.066707 20 The KFC near the beach has a higher mean and a higher standard deviation You could also find percentiles Beach Inner city Min (0 th percentile) 169 1025 Q1 (25 th percentile) 293 1201 Median (50 th percentile) 3099.5 1439 Q3 (75 th percentile ) 3216 1520 Max (100 th percentile) 3937 1919 Discuss the differences between the beach store and the inner city store with your tutor.
Sample data based on survey questions Suppose you are the manager of a Gym and you give your customers the following survey survey question 1: Are you male or female?___________ This question should be thought of a is a categorical variable, becaue the answer is one of the categories “male” or “female” survey question 2: What is main reason you go to the gym ? Select one *Lose weight *gain strength *Both to gain strength or lose weight *Other reason This question should be thought of a is a categorical variable, becaue the answer is one of 4 categories Survey question 3: How much time do you spend on the cardio machine (in minutes) ? This question should be thought of as a Quantitative variable because it records the quantity (amount) of time spent on the machine machine Survey question 4: How much time do you spend on the weight machine (in minutes)? This question should be thought of as a Quantitative variable because it records the quantity (amount) of time spent on the weight machine And you get the following answers from 10 people Which customer Gender ? Why Do you go to gym? Cardio minutes Weight minutes Customer 1 Male gain strength 0 20 Customer 2 Male gain strength 0 30 Customer 3 Male gain strength 20 20 Customer 4 Male lose weight 30 15 Customer 5 Male lose weight 10 25 Customer 6 Female gain strength 0 20 Customer 7 Female lose weight 20 10 Customer 8 Female lose weight 30 10 Customer 9 female lose weight 45 0 Customer 10 Female lose weight 40 0 This is a sample of sample size n=10 with 4 variables “Gender” and “why do you go the gym” are categorical and the variables “Time on the cardio machine” and “Time on the weight machine” are quantitative *It should be clear that if there many variables you have to give each variable a column. Excel expects you to do this because Pivot tables and filters need variables to be in columns
Case 1 working with two categorical variables page 1 of 2 If you have a dataset with different categories, it is very common to want to compare the categories Click the link for the excel guide Example you want to find the relationship between 2 variables Gender ? Why Do you go to gym?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture