Choose an article from the newspaper, an online source, or a magazine, then identify the descriptive statistics included in the article. Were the statistics appropriately described in the article? Explain. Discuss if the descriptive statistics used in your source supported the arguments made in it. Were the descriptive statistics misleading? Explain.
Category: Statistics
Analyze Numerical Summaries of Data Using Excel and SPSS
Instructions
In this assignment, you will answer the following questions using both Excel and SPSS software. Results from these programs should be copied and pasted into a Word document for submission.
For Questions 1 and 2, you will need to input the data provided below into both Excel and SPSS. For Questions 3 and 4, you will use the dataset files provided.
- Suppose that a quality assurance manager took a random sample from calls to a call center. The sample consisted of 18 calls, and the manager recorded their lengths. Results from the sample, in minutes, are given below: 2.20 1.95 2.15 2.08 1.85 1.92
2.23 2.19 1.98 2.07 2.24 2.31
1.96 2.30 2.27 1.89 2.01 1.93
a. Use Excel to calculate the mean, median, and standard deviation for these data.
b. Use SPSS to calculate the mean, median, and standard deviation for these data.
c. Use SPSS to create a histogram of these data.
d. Interpret these results and explain any differences you find between the two software tools (Hint. The results should be identical). Do you find one or the other easier/and or more useful?- A manager of a food manufacturing company wants to estimate the percentage of fat in one of its salad dressings. A sample of 20 bottles was taken, and the results are given below.
15.88 19.88 21.16 20.37 22.77 20.65
18.60 18.91 21.77 21.64 18.62 18.41
20.15 17.07 19.91 21.07 16.49 21.21
17.98 20.22
a. Use Excel to calculate the mean, median, and standard deviation for these data.
b. Use SPSS to calculate the mean, median, and standard deviation for these data.
c. Use SPSS to create a histogram of these data.
d. Interpret these results and explain whether or not it is honest for the manufacturer to state that the fat content is 20%? Explain your answer.- A manager is worried that her employees are not engaged at work. She finds an employee engagement survey and administers it to her workers. The individual scores are provided in the dataset file.
a. Use Excel to calculate the mean, median, and standard deviation for the employee engagement data.
b. Use SPSS to calculate the mean, median, and standard deviation for the employee engagement data.
c. Use SPSS to create a histogram of these data.
d. Conduct an analysis of the “age” and “gender” variables using the appropriate measures of central tendency and dispersion. Use SPSS only. Also, create an appropriate graphic for each variable.
e. Interpret the results for employee engagement, age, and gender. Identify what you believe the next step should be in this analysis. - A shop supervisor wants to understand his workers better. He hires a consultant who tells him that he should ask employees questions related to their lives if they feel comfortable answering these questions. Please use SPSS to analyze the following variables, create appropriate figures and charts, and explain the results of each variable. Do not compare the variables in this assignment.
a. Age
b. Model of car
c. Rent or own their home
d. Hobbies
e. How happy they are (on a five-point scale)
This assignment should be between 4-6 pages. Include a minimum of 3 resources. Two of these will be Excel and SPSS.
Your assignment should demonstrate thoughtful consideration of the ideas and concepts presented in the course and provide new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards
U.S. Bureau of Labor Statistics
Scenario
You are preparing to do a job search for your desired career in human resources in health care. You begin an occupational search by researching websites to survey job outlook, annual wages, job training requirements, and how much education or experience is needed to perform the job in your selected HR role.
Preparation
Use the following occupational job search tools to assist you in your HR job search:
U.S. Bureau of Labor Statistics
O*Net Occupation Keyword Search
You can use each site’s search function to enter additional keywords and explore specific HR jobs that might interest you.
Assignment Deliverable
Respond to the following prompts in at least 90 words each:
Identify your desired role/position in the health care industry.
Detail the experience or skills you have that will make you a good fit for this role or position. Explain how your current skill sets are transferrable to the selected desired position and how you see yourself excelling in that role.
Multinational companies
Examine an MNC that faced a human rights or environmental scandal.
Critique the organizational responses of the MNC. What did it do well in the aftermath of the scandal? How could it have improved its response?
Your response should focus on the following topics:
Selection of a MNC
What human right or environment scandal occurred in the company during which time period
Reason for involving in the scandal
Authorities involved or in charge of the scandal
Its impact on the stakeholders of the company
Action taken in response to the scandal
Regulatory changes made after the scandal
Your recommendations or improvements towards action taken in response to the scandal
Applied Statistics Discussion
In real-life applications, statistics helps us analyze data to extract information about a population. In this module discussion, you will take on the role of Susan, a high school principal. She is planning on having a large movie night for the high school. She has received a lot of feedback on which movie to show and sees differences in movie preferences by gender and also by grade level.
She knows if the wrong movie is shown, it could reduce event turnout by 50%. She would like to maximize the number of students who attend and would like to select a PG-rated movie based on the overall student population’s movie preferences. Each student is assigned a classroom with other students in their grade. She has a spreadsheet that lists the names of each student, their classroom, and their grade. Susan knows a simple random sample would provide a good representation of the population of students at their high school, but wonders if a different method would be better.
You can review the student demographics here: Module One Discussion Data PDF. – Attached to the assignment in a screenshot
In your initial discussion post, specifically, address the following:
Introduce yourself and describe a time when you used data in a personal or professional decision. This could be anything from analyzing sales data on the job to making an informed purchasing decision about a home or car.
Describe to Susan how to take a sample of the student population that would not represent the population well.
Describe to Susan how to take a sample of the student population that would represent the population well.
Finally, describe the relationship of a sample to a population and classify your two samples as random, systematic, cluster, stratified, or convenience.
PERT methodology
Case II – Suppose that you rented an apartment. You need to furnish the apartment. You
will need to develop a potential expense for each piece of furniture and a total budget.
Develop a hypothetical expense budget having at least 10-line items using the PERT
methodology and compute the expense point where you are at least 90% sure that your
expenses will not exceed this amount. Include all calculations, showing the steps as done in
the class exercise. The standard deviation should be computed, and the z value specified.
For each piece of furniture and the 3-point estimates, include a link to an internet reference
where you retrieved the price estimate.
You can do this below the PERT table.
PERT methodology
Case II – Suppose that you rented an apartment. You need to furnish the apartment. You
will need to develop a potential expense for each piece of furniture and a total budget.
Develop a hypothetical expense budget having at least 10-line items using the PERT
methodology and compute the expense point where you are at least 90% sure that your
expenses will not exceed this amount. Include all calculations, showing the steps as done in
the class exercise. The standard deviation should be computed, and the z value specified.
For each piece of furniture and the 3-point estimates, include a link to an internet reference
where you retrieved the price estimate.
You can do this below the PERT table.
Descriptive statistics regarding annual revenues
Case I – Select a major company and perform some descriptive statistics regarding its annual revenues over any past ten calendar years between 2000 and 2022. List the revenues by year and the source of the information. Then, calculate the population standard deviation of the revenues by year, calculate the mean revenue of the data set, calculate the median revenue of the data set, the mode, 1st quartile and 3rd quartile. Generate a descriptive statistics summary using Analysis Toolpak, then draw a box and whiskers diagram of the data set.
All formula calculations must be shown in Excel – any answers provided that do not have all supporting calculations shown will receive no credit.
Select a second company: Perform the same calculations in Excel.
Then compare the standard deviations of the two companies and analyze as to which company, if this history is a good predictor of future performance next year, is riskier in terms of sales revenues, justifying your answer. Write your answer in full sentences in a paragraph-format as it relates to the case. Do not provide generic answers, definitions, or answers retrieved from other sources unrelated to the case. Your answer should be derived from the numbers and statistics you just generated, not based on the fame/reputation of the company itself. The answer to this question can be written in a block in the same excel file.
Variety of rehabilitation methods and statistics from traditional incarceration
Prevention. You have learned about a variety of rehabilitation methods and statistics from traditional incarceration to new-age rehabilitation programs. Choose one method of tertiary crime prevention that you believe works best and explain why you think it works better or worse than incarceration in your own words. Support your answer with the class material and independently found material. Lastly, make a conclusion as to whether or not that program should continue.
Correlation between the resting and after-exercising heart rate
In this lesson, you will run a correlation between the resting and after-exercising heart rates to determine if a linear relationship exists between the two variables and how strong the relationship is.
Steps
Open the Heart Rate Data Set in Excel and identify the X-variable (resting heart rates for all 200 participants) and the Y-variable (after-exercise heart rates for all 200 participants).
Use the Scatter Plot function in the Insert Charts section of Excel to create a scatter plot of the X and Y variables.
Add a trendline to the scatter plot.
Use the Data Analysis tools in Excel to find the regression equation.
In a Word document, describe the relationship between the X-variable (resting heart rate)and the Y-variable (after exercise heart rate).
Graph the scatter plot with a trend line. Does it appear there is a linear relationship? What does this mean?
Calculate the correlation coefficient r using excel. Is this r (value) high compared to +1? Based on the correlation coefficient is the relationship strong?
Use excel to find the regression equation. Identify the slope. What does it tell us in terms of our heart rate data?
Heart rate before and after exercise
M=0 F=1 Resting After Exercise
0 55.0 65.0
0 67.7 79.4
0 80.3 93.4
0 85.2 97.7
0 86.3 99.7
0 76.6 83.7
0 94.4 101.9
0 86.4 100.6
0 83.4 97.4
0 89.8 97.4
0 88.7 97.1
0 78.4 87.2
0 67.0 79.9
0 85.0 100.0
0 86.2 95.9
0 83.9 93.9
0 78.1 87.2
0 64.0 70.7
0 72.8 86.7
0 65.0 75.0
0 80.2 83.3
0 78.2 86.0
0 62.0 88.0
0 75.5 84.4
0 82.7 89.1
0 87.7 95.1
0 76.0 88.7
0 73.4 82.7
0 80.1 94.6
0 77.6 84.6
0 76.6 86.4
0 85.6 96.2
0 74.2 82.1
0 79.0 91.6
0 74.6 86.7
0 88.8 98.8
0 82.1 85.6
0 77.6 80.6
0 77.9 83.8
0 72.0 93.9
0 81.6 90.3
0 91.2 100.6
0 80.3 88.0
0 76.7 91.8
0 88.4 103.0
0 75.2 86.5
0 75.2 84.9
0 73.1 71.9
0 77.0 84.7
0 59.0 68.2
0 84.9 96.0
0 87.5 105.9
0 75.6 84.3
0 84.0 90.4
0 78.2 94.0
0 86.6 90.6
0 84.9 95.1
0 78.8 90.4
0 69.4 82.6
0 78.3 91.1
0 76.9 92.3
0 84.2 87.9
0 76.3 85.9
0 86.3 99.7
0 72.3 80.9
0 81.8 93.8
0 92.8 99.8
0 74.8 90.2
0 91.7 99.2
0 71.0 87.0
0 96.1 100.2
0 82.5 95.1
0 81.9 97.5
0 89.7 94.8
0 81.4 100.9
0 74.8 94.0
0 88.1 102.1
0 69.2 81.4
0 78.8 90.9
0 85.3 94.2
0 74.8 81.3
0 77.7 89.9
0 78.0 89.8
0 80.5 95.3
0 75.4 84.8
0 81.5 84.2
0 73.9 85.2
0 69.4 74.1
0 89.4 96.7
0 70.9 82.0
0 82.9 90.2
0 60.1 79.0
0 74.5 75.6
0 92.3 102.2
0 87.7 98.0
0 78.9 89.7
0 79.8 81.5
0 85.5 97.4
0 87.3 94.1
0 77.8 97.8
0 71.0 80.1
0 70.0 90.7
0 74.8 83.7
0 69.2 79.4
0 80.5 87.4
0 89.4 99.2
0 74.5 88.0
0 70.0 100.0
1 60.0 78.1
1 79.2 90.4
1 80.5 101.3
1 75.4 93.1
1 83.7 90.5
1 73.9 89.1
1 76.0 90.8
1 85.2 93.5
1 82.1 93.5
1 76.3 87.0
1 97.0 104.5
1 81.5 86.5
1 65.3 86.3
1 60.8 86.7
1 78.5 89.9
1 60.4 97.6
1 89.8 92.9
1 87.8 98.5
1 76.2 89.9
1 74.2 88.8
1 67.4 78.8
1 75.5 80.2
1 80.0 90.2
1 76.4 88.0
1 60.0 95.7
1 89.2 96.9
1 83.3 87.7
1 85.8 90.4
1 75.3 84.1
1 77.9 99.0
1 70.0 83.0
1 88.0 94.2
1 86.9 95.0
1 87.1 95.9
1 60.3 82.7
1 81.2 90.7
1 82.9 91.9
1 87.4 103.6
1 83.0 90.0
1 76.8 83.3
1 76.9 87.7
1 79.8 88.2
1 83.2 93.0
1 79.5 88.6
1 82.4 89.3
1 80.8 84.2
1 83.2 94.5
1 71.6 81.5
1 82.8 93.1
1 76.8 92.8
1 93.2 89.4
1 91.4 100.9
1 97.3 103.3
1 88.3 90.1
1 80.6 85.2
1 87.4 91.7
1 96.5 99.3
1 77.9 91.6
1 76.1 84.1
1 85.2 89.7
1 68.6 72.8
1 79.4 91.0
1 85.2 99.1
1 74.3 85.6
1 74.3 89.2
1 78.5 98.5
1 80.4 90.8
1 82.9 85.9
1 78.9 90.7
1 78.6 87.0
1 87.5 93.9
1 78.9 91.4
1 80.0 89.1
1 80.4 89.2
1 88.3 90.5
1 80.6 95.9
1 85.8 90.5
1 84.6 93.0
1 90.5 101.2
1 92.4 101.2
1 84.4 96.7
1 82.3 86.9
1 77.2 85.8
1 83.3 82.1
1 86.2 98.9
1 81.3 97.7
1 90.2 96.4
1 78.4 85.5
1 84.7 90.9
1 89.7 94.3
1 78.4 88.0
1 70.0 80.0