MATH309 M4 Midterm Exam Pampolim

MATH 309 – Statistics Midterm Exam This Assessment is worth 15% of your overall grade. Deadline See Tracking Calendar. Completing this Assessment will help you to meet the following: Course Outcomes:  Organize data for analysis in the form of graphs, tables, and frequency distributions  Calculate statistical data for measures of central tendency and dispersion  Investigate dispersion through normal distributions using range, mean, standard deviation and z scores  Collect, organize, and interpret data to perform regression analysis  Measure location, variation, probabilities, distributions, and expectations Directions You must submit a Microsoft Word document (Copy your Excel work into Word) and upload your work into the Mid Term Exam folder by the due date. You will also submit your Excel document into the Mid Term Exam folder showing your work for each problem. All the exam questions are based on questions from Module 1 through Module 4 homework assignments. For the mid-term, you are welcome to use the videos and resources from your Blackboard lecture folders and the videos in your homework in Blackboard. A list of all the videos assigned in your homework is given at the end of this document. Part 1 Use the data from Table 1 below to answer Questions 1 - 8 of the exam. Table 1 shows data of 20 people surveyed about their current credit card balances. The data set includes variables regarding an individual’s gender, ethnicity, age, current credit care balance and the number of credit cards they currently have open.

MATH309 Midterm Exam 2 ID Gender Ethnicity Age Loan balances # of cards 1 Female Caucasian 51 950 5 2 Male African American 71 557 5 3 Male Asian 51 650 4 4 Female Hispanic 62 150 3 5 Female indigenous American 25 70 2 6 Male Caucasian 47 701 5 7 Male African American 55 0 3 8 Female Asian 33 45 4 9 Female Hispanic 12 230 2 10 Male Caucasian 38 1200 3 11 Trans gender African American 47 45 4 12 Male Asian 63 645 2 13 Male Hispanic 45 550 1 14 Female Caucasian 33 700 2 15 Female Caucasian 21 600 3 16 Female Caucasian 18 880 11 17 Female African American 19 5 2 18 Male African American 40 0 1 19 Male Hispanic 101 699 2 20 Male indigenous American 46 325 3 Table 1: Survey data on current credit card balance 1. Input the data from Table 1 into Excel. Calculate the descriptive statistics on the age column (Column D) of the table. (See video link on page 7 if needed) A) Paste your Excel descriptive statistics output for the age variable below. Column1 Mean 43.9 Standard Error 4.705483 9 Median 45.5 Mode 51 Standard Deviation 21.04356 4 Sample Variance 442.8315 8 Kurtosis 1.519657 Skewness 0.842382 Range 89 Minimum 12

MATH309 Midterm Exam 4 Pie Chart below. (See video link on page 7 if needed) 53% 47% Genders Male Female 5. Use the data from Table 1 to complete the frequency table of Ethnicity (Column C) for the 20 participants. You can use the =countif (B2:B21, “Caucasian”) function in Excel. A. Complete the frequency table of Ethnicity below. Ethnicity Frequenc y Caucasian 6 Asian 3 African American 5 B. Using the ethnicity table, create a bar chart of Ethnicity of the Survey Participants. Make sure to include a title and that each axis is clearly labeled. Paste your Bar Chart below. Caucasian Asian African American 0 1 2 3 4 5 6 7 Ethnicity Frequency Ethnicity

MATH309 Midterm Exam 5 6. Complete the Frequency Distribution table below for the variable Credit Card Balance (Column E). Use a bin width of 400. (See video link on page 7 if needed) Frequency Distribution Frequenc y 0-400 9 401-800 8 801-1200 3 1201-1600 0 1601-2000 0 2001-2400 0 A) Paste the Frequency Distribution Chart below for Credit Card Balance. B) Create a histogram of the Credit Card balance data. Paste your graph below. C) Describe the shape of the histogram. Would this be considered a unimodal, symmetric distribution? Unimodal 7. Continuing to focus on Credit Card Balance (Column E). A. Calculate the 5-number summary for Credit Card Balance (Column E). Paste the summary below. (See video link on page 7 if needed) Free B. Create a Box plot (Box & Whisker) of Credit Card Balance. Paste your graph below.

MATH309 Midterm Exam 7 B. Given your answer to Part A, which measure of Central Tendancy (Mean, Median, Mode) would best represent the data set. Why? Median, mean effected by the outlier, mode you might not have a duplicate. C. If the person with 11 credit cards were removed from the data set. Describe the shape of the distribution in Figure 1. Symmetrical Part 2 10. 11 slips of paper are put into a bag numbered from 1 to 11. One slip is randomly selected from the bag. We are interested in selecting odd numbers. A. List the even numbers from 1 – 11. 2, 4, 6, 8, 10 B. What is the probability of selecting an odd number from the bag? 6/11 11. If the news gives a prediction of a 4% chance of rain tomorrow, what is the probability that it will not rain tomorrow? 96/100 Use the data in Table 2 to answer Questions 11 – 12. A survey was given to students and they were asked to rate their “Rate your intellegence on a scale of 1 to 10”. The results of survey are given in Table 2 as a distribution of intellegence rating. Table 2: Intellegence Rating of students. Intellegence Rating Frequenc y 5 20 6 15 7 21 8 17 9 1 12. If we assume the participants in the survey of students are a “typical” sample of students. What is the probability of selecting a student with an intellegence rating of 7? Make sure to show your calculations for full credit. 21/74

MATH309 Midterm Exam 8 13. What is the probability of selecting student with a Intellegence Rating of 7 or 8? P(8 or 9). Use the Addition Rule. Show your work for full credit. 38/74. Which can also be 19/37. Part 3 A survey is taken on average commute time to work. The mean and standard deviation of the survey are as follows: Mean commute time: 30 minutes Standard deviation: 10 minutes 14. Use the mean and standard deviation above to calculate the z-score of a 19 minute commute to work. Explain what this z-score tells us. (19-30)/10= -1.1 Left of the mean. Videos Linked to Module 1 through Module 4 Homework Assignments You can utilize the following video links from your previous homework assignments as a reference to complete the Midtem Exam. Module 2 Developing a Bar Chart in Excel Creating a Column Chart or Bar Chart in Excel Developing a Pie Chart in Excel Excel Pie Chart - Introduction to How to Make a Pie Chart in Excel Create a Frequency Distribution Chart in Excel Create a Frequency Distribution Table in Excel Create a Histogram in Excel Create a Histogram with Excel Module 3 Overview of the Normal Distribution The Normal Distribution and the 68-95-99.7 Rule Understanding z-scores Why Do We Need z Scores? Calculating Descriptive Statistics in Excel Statistics in Excel - Mean (Average), Median, Mode, and Standard Deviation Calculate 5-number summary and Create a boxplot in Excel Five Number Summary and Boxplots in Excel 2016 Calculating Percentiles in Excel