Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sex Brand 0 1 0 0 1 0 1 1 1 0 0 0 1 1 1 1 0 1 0 1 0 1 0
Sex Brand 0 1 0 0 1 0 1 1 1 0 0 0 1 1 1 1 0 1 0 1 0 1 0 1 1 0 1 0 0 1 1 0 0 1 1 0 1 0 1 0 1 Brand Name 1 Brand A=1 2 Brand B=2 2 1 Female=1 1 Male=0 2 1 2 2 1 1 Sex 2 Mode= 2 0 2 Median= 1 0 1 Mean= 1 0.4779220779 2 1 2 Brand Name 1 Mode= 1 1 2 Median= 1 1.5 2 Mean= 2 1 1 2 1 How Many Polled=385 2 Female=184 1 Male=201 1 1 How many chose Brand A 2 190 2 Brand B =196 2 2 1 1 2 1 Sex Mean 0.47792208 Standard Erro 0.02549063 Median 0 Mode 0 Standard Devi 0.50016231 Sample Varia 0.25016234 Kurtosis -2.00255457 Skewness 0.08874404 Range 1 Minimum 0 Maximum 1 Sum 184 Count 385 Confidence Le 0.05011868 Sex vs Brand 2.5 2 1.5 Brand 1 0.5 0 0 0.2 0.4 0.6 Sex 0 0 1 1 0 1 1 0 0 1 1 0 0 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 2 2 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 1 1 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 1 1 1 0 0 0 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 1 1 1 2 1 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 1 1 1 2 1 2 1 1 1 0 1 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 1 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 1 1 1 2 1 2 1 1 1 2 2 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 1 1 1 2 1 2 1 1 1 2 2 1 2 1 0 1 0 1 0 1 0 0 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 0 0 0 0 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 0 0 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 0 1 0 0 1 0 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 0 1 0 1 1 1 0 1 1 2 2 2 1 2 1 Brand Mean 1.49090909 Standard Erro 0.0255113 Median 1 Mode 1 Standard Devi 0.50056786 Sample Varia 0.25056818 Kurtosis -2.00913111 Skewness 0.03651206 Range 1 Minimum 1 Maximum 2 Sum 574 Count 385 Confidence Le 0.05015932 Sex vs Brand 0.4 0.6 Sex 0.8 1 1.2 t-Test: Two-Sample Assuming Equal Variances Sex Brand Mean 0.47792208 1.49090909 Variance 0.25016234 0.25056818 Observations 385 385 Pooled Varian 0.25036526 Hypothesized 0.05 df 768 t Stat -29.4751682 P(T<=t) one-ta1.2618E-128 t Critical one- 1.64684011 P(T<=t) two-ta2.5236E-128 t Critical two- 1.96305767 Sex Brand Mean 0.47792208 Standard Erro 0.02549063 Median 0 Mode 0 Standard Devi 0.50016231 Sample Varia 0.25016234 Kurtosis -2.00255457 Skewness 0.08874404 Range 1 Minimum 0 Maximum 1 Sum 184 Count 385 Confidence Le 0.05011868 Mean 1.49090909 Standard Erro 0.0255113 Median 1 Mode 1 Standard Devi 0.50056786 Sample Varia 0.25056818 Kurtosis -2.00913111 Skewness 0.03651206 Range 1 Minimum 1 Maximum 2 Sum 574 Count 385 Confidence Le 0.05015932 Running head: DESCRIPTIVE STATISTICS Descriptive Statistics Courtney Taylor QNT/561 June 6, 2016 Dr. Heidi Carty 1 DESCRIPTIVE STATISTICS 2 Descriptive Statistics Sex Central Tendency: Mode=0 Males Mean=0.478 Dispersion: Standard Deviation .5002 Number: 385 Min/Max:Min 184 Females Max 201 Males Brand Central Tendency: Mode=1 Brand A Mean= 1.49 Dispersion: Standard Deviation .5057 Number: 385 Min/Max:Min 290 Brand A and 196 Brand B Descriptive Statistics Interpretation Sex It was important to break down if we were surveying men or women to see how the standard would differ, if that play affect on the data we were achieving. We broke it down from men and woman and standardized each one with a number in order to complete in Excel. The descriptive statistics will be analyzed below. In Appendix A through C will show the different ways the sex was seen. Brand Variable two we utilized the brand that the customer was choosing. Brand A and Brand B were both given a value in order to see how a customer would choose and could be broken down into our data charts to be summarized. In the Appendix's below data will be shown. Descriptive Statistic Interpretation DESCRIPTIVE STATISTICS 3 Sex Throughout the survey we had more males surveyed then females. This was by about twenty plus people which played a factor in how the first metric was seen. The mean and median could have been skewed because of the value of zero being utilized. Brand The choice of brands was very different then the numbers we saw for the first metric. The brand was a difference of six individuals who choose brand B over brand A. Although some metrics were very similar and put the two values very close and similar. The brand of choice from our surveyors was what we were watching and trying to determine which brand would be chosen over the other. DESCRIPTIVE STATISTICS 4 Appendix A Raw data used in the analysis Sex Brand 0 1 1 2 0 2 0 1 1 1 0 2 1 1 1 2 1 2 0 1 0 1 0 2 1 2 1 2 1 1 1 1 0 1 1 2 0 1 1 2 0 1 1 1 0 2 1 1 1 2 0 2 1 1 0 2 0 1 1 2 1 1 0 1 0 1 1 2 1 2 0 2 1 2 0 1 1 1 0 1 0 0 1 1 0 1 1 0 0 1 1 0 0 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 2 1 2 2 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 0 1 0 1 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 1 2 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 2 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 1 DESCRIPTIVE STATISTICS 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 1 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 2 1 0 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 0 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 5 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 0 0 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 2 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 0 0 0 1 1 1 0 0 0 1 1 1 0 0 0 1 0 1 1 2 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 2 1 2 1 2 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 1 1 0 0 0 0 1 0 0 1 0 1 0 1 0 1 1 1 0 1 1 2 1 1 1 2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 2 2 2 1 1 1 2 2 2 1 2 1 DESCRIPTIVE STATISTICS 6 Appendix B Charts and Tables Sex Brand Mean 0.47792207 Mean 1.490909091 Standard Error 8 0.02549063 Standard Error 0.0255113 Median Mode Standard Deviation Sample Variance 2 0 0 0.500162311 0.25016233 Median Mode Standard Deviation Sample Variance 1 1 0.500567859 0.250568182 Kurtosis 8 - Kurtosis - 2.00255457 2.009131112 Skewness 4 0.08874403 Skewness 0.036512057 Range Minimum Maximum Sum Count Confidence 8 1 0 1 184 385 0.050118685 Range Minimum Maximum Sum Count Confidence 1 1 2 574 385 0.050159323 Level(95.0%) Level(95.0%) DESCRIPTIVE STATISTICS 7 Appendix C Descriptive Statistics Brand Name Brand A=1 Brand B=2 Female=1 Male=0 Sex Mode= 0 Median=0 Mean=0.477922078 Brand Name Mode= 1 Median=1.5 Mean=1 How Many Polled=385 Female=184 Male=201 How many chose Brand A 190 Brand B =196
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started