Category: Statistics

Attached Files (PDF/DOCX): annotated-Presentation20Template20DHSc.pdf

Note: Content extraction from these files is restricted, please review them manually.

Instructions

Use the information from the week 1 project assignment and add the following to it:

• Select a sample from the data: Use a random selection method, such as simple random selection or systematic random selection, to form your sample of at least 20 data points. The sample can be larger, but 20 is the minimum.
• List the original and sampled data points.
• Describe the sampling: Describe the sample size and how it was obtained. If you used a random selection method, describe what you did.

• Descriptive Statistics. Use Excel to do the following:
  • Find the mean, mode, median, and standard deviation of your data set. You may include other calculations if they support your work.
  • Create at least two graphs (such as box plots, scatter plots, stem-and-leaf, histograms, etc.) that depict the data.
• Interpret and explain your descriptive statistics and graphs. What do they indicate about the sample? Do they seem to support the claim you made in the Project, Week 1?

Upload your assignment, including your Excel spreadsheet, following the submission instructions found below.Some Rubric

Total Points: 100

Answer the following questions based on what you have learned in Chapter 2 so far. You will receive points as listed below. Once you have submitted your answers you will be able to see other students’ submissions. Please comment on at least one other student’s post; this will be worth 1 additional point.

Were the subjects weighed or did they report their weights?

One fascinating aspect of statistics is that we can some-times learn how data were collected by analyzing the data. Table 2-12 and Table 2-13 both include weights (pounds) of 50 randomly selected adult male subjects. When subjects are included in the National Health and Interview Survey, there is a requirement that subjects must be weighed on a scale. One of the two data sets was obtained by using a scale to actually weigh the subjects, but the other data set consists of weights that were reported by the subjects when they were asked how much they weighed. With a clever use of common sense, we know that when subjects report their weights, the results are often rounded to a value conveniently ending in a 0 or 5. Given this, we are able to deduce how the data were collected by analyzing the last digits of the weights.

TABLE 2-12 Weights (lbs) of 50 Adult Males

TABLE 2-13 Weights (lbs) of 50 Adult Males

Use the methods from Chapter 2 to address the following questions:

1. Construct a frequency distribution and histogram of the last digits of the weights in Table 2-12. (2 points)

2. Construct a frequency distribution and histogram of the last digits of the weights in Table 2-13. (2 points)

3. Compare the results from questions 1 and 2. Determine which table includes weights obtained by using a scale and which table includes weights that were reported by the subjects. (1 point)

Answer the following questions based on what you have learned in Chapter 2 so far. You will receive points as listed below. Once you have submitted your answers you will be able to see other students’ submissions. Please comment on at least one other student’s post; this will be worth 1 additional point.

Were the subjects weighed or did they report their weights?

One fascinating aspect of statistics is that we can some-times learn how data were collected by analyzing the data. Table 2-12 and Table 2-13 both include weights (pounds) of 50 randomly selected adult male subjects. When subjects are included in the National Health and Interview Survey, there is a requirement that subjects must be weighed on a scale. One of the two data sets was obtained by using a scale to actually weigh the subjects, but the other data set consists of weights that were reported by the subjects when they were asked how much they weighed. With a clever use of common sense, we know that when subjects report their weights, the results are often rounded to a value conveniently ending in a 0 or 5. Given this, we are able to deduce how the data were collected by analyzing the last digits of the weights.

TABLE 2-12 Weights (lbs) of 50 Adult Males

TABLE 2-13 Weights (lbs) of 50 Adult Males

Use the methods from Chapter 2 to address the following questions:

1. Construct a frequency distribution and histogram of the last digits of the weights in Table 2-12. (2 points)

2. Construct a frequency distribution and histogram of the last digits of the weights in Table 2-13. (2 points)

3. Compare the results from questions 1 and 2. Determine which table includes weights obtained by using a scale and which table includes weights that were reported by the subjects. (1 point)

Data measurement is an important aspect of data analytics. Identifying trends in key attributes of data is a fundamental measurement for various aspects of business data and an important skill for business professionals. In this scenario, you are a business consultant trainee assigned to work with your first client, TC Ice Cream.

TC Ice Cream is a private-label ice cream manufacturer. Located in the northern region of Michigan, TC Ice Cream specializes in premium ice cream flavors. TC Ice Cream is categorized in the food/agriculture business sector. The company has gained popularity over the past three years due to recent publicity such as winning awards on network television food shows, hosting and attending promotional events, and actively using social media.

The management team of TC Ice Cream is looking to see if there are specific trends that could be identified to help them improve their operations and sales and grow their business. You will report the research and analysis of the data to the TC Ice Cream management team. Periodically, you will be expected to apply your training and submit a deliverable to the management team.

The TC Ice Cream information technology team has provided you with a data set, TC Ice Cream Excel Workbook, that contains data about orders over a span of three years.

You will use the data variables to create descriptive statistics and visualizations for TC Ice Cream. This will enable you to effectively and efficiently gain helpful insights into the data and its attributes. You will continue to delve further into your analysis of TC Ice Cream throughout the course.

Prompt

For this assignment, you will perform the following steps as you begin your analysis of the data provided.

Within the , review the sheet Data Dictionary. This will help you understand the data provided and specific information about each variable. Review the sheet TC Ice Cream Data. DO NOT EDIT this data.

Next, you will calculate the central tendency of the TC Ice Cream data set using the average, median, minimum, maximum, and range. You will also create multiple charts to present the descriptive analysis you performed.

Specifically, you must address the following rubric criteria:

1. Create a table to represent the average, median, minimum, maximum and range values for each variable. Within the TC Ice Cream Excel Worksheet, use the sheet Descriptive Statistics to create the following table.
   • Use Excel formulas to calculate the average, median, minimum, maximum, and range values for each of the quantitative variables (Quantity Sold, Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions).
2. Create charts to represent the key variables of the data. Within the TC Ice Cream Excel Worksheet, use the sheet Overall Analysis to create the charts listed below. It is recommended that you use pivot tables/pivot charts to create the visualizations. Feel free to use this sheet to create any additional visualizations that might help you better understand the data.
   • Create a pie chart using the qualitative variable Region and the quantitative variable Quantity Sold to provide a visualization of percentage overview of quantity sold by region.
   • Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by month.
   • Create a bar chart using the qualitative variable Flavor and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by flavor.
3. Use the Module One PowerPoint Template to create a PowerPoint presentation that explainsthe data and its key variables. This should include key visualizations and analysis to support your answers. The PowerPoint Template includes specific questions to answer as you explain the data and variables. Use the visualizations and data analysis you created in the Descriptive Statistics and Overall Analysis sheets to support your analysis.

What to Submit

• TC Ice Cream Excel Workbook: Submit the . For this assignment, work should be completed in the Descriptive Statistics and Overall Analysis sheets.
• PowerPoint Presentation: Submit a PowerPoint Presentation using the . If references are included, they should be cited in APA format. Consult the for more information on citations.

Module One Excel Workbook Rubric

Progress Check

Check your progress. Use this activity to assess whether you can:

• Describe blinding in an experiment’s design.
• Explain why blinding is necessary for a given experiment.

Directions

Use the drop-down menu to learn about the three steps needed to complete this assignment.

Context

A newspaper story in Knight Ridder Newspapers described an experiment in an article with the headline Doctor Dogs Diagnose Cancer by Sniffing It Out.

In the experiment researchers trained dogs to identify people with breast or lung cancer. The dogs were trained to lay down if they detected cancer in a breath sample. After the training, dogs sniffed different breath samples of people with and without cancer. Impartial observers watched the dogs and decided when the dog identified a person as having cancer. Researchers then revealed the condition of the person who gave the breath sample and determined if the dog had correctly identified the presence of cancer.

The newspaper states, The researchers blinded both the dog handlers and the experimental observers to the identity of the breath samples.

Prompt

1. Explain what the following sentence means. The researchers blinded both the dog handlers and the experimental observers to the identity of the breath samples.
2. Explain why blinding in this experiment is important.

Module 6 Discussion Board

Use the Module 6 (opens in a new tab) to ask questions or provide feedback about the problems in any Module 6 activity – including this peer-reviewed assignment.

Review Feedback

• Instructor feedback is only available after an assignment is graded.
• Use these (opens in a new tab) to learn how to review feedback.

Click the “Next” or > button to continue.

Content by Cuyamaca College math faculty and licensed under the .

Rubric

Formative Assessments

Total Points: 10

Progress Check

Use this activity to assess whether you and your peers can:

• Compare distributions to determine whether the primary goal of random assignment is achieved.

Directions

Use the drop-down menu to learn about the three steps needed to complete this assignment.

Context

A high school student named David Merrell did an experiment to examine if music affects the ability of mice to run a maze. The explanatory variable was exposure to music. He had three treatment groups: one group listened to heavy metal music by the group Anthrax. A second group listened to Mozart. The third group never heard music. This last group is the control group.

The response variable was the average time (in seconds) to complete three runs. Every week the mice ran the maze three times. Merrell recorded each mouse’s average time for the week.

Direct controls of potential confounding variables:

• Merrell trained all of the mice to run the same maze.
• He gave all mice the same amount of food and light.
• All mice had the same approximate age and weights.
• During the treatment phase, the mice were exposed to the treatment for the same amount of time, e.g. mice heard music at 70 decibels for 10 hours a day for a month.

Results:

By the end of the month, the Anthrax group was much slower at running the maze. The Mozart group was much faster. The dotplots below show average run times for the first and last week of the experiment. Each dot represents one mouse. The X-value is the mouses average run time for the week. (Each mouse ran the maze 3 times each week.) The blue line is the mean run time for each treatment group.

If you are curious, here is a video of Merrell explaining his experiment.

()

Prompt

Merrell claims that he randomly assigned mice to treatment groups. Does the data shown in the dotplots above support his claim? Why or why not?

Module 6 Discussion Board

Use the Module 6 (opens in a new tab) to ask questions or provide feedback about the problems in any Module 6 activity – including this peer-reviewed assignment.

Review Feedback

• Instructor feedback is only available after an assignment is graded.
• Use these (opens in a new tab) to learn how to review feedback.

Click the “Next” or > button to continue.

Content by Cuyamaca College math faculty and licensed under the .

Rubric

Formative Assessments

Total Points: 10