Each Statistics in the Media discussion assignment has two components (your post and your comments):
Your own post (6 points)

Find an example of statistical data portrayed in the popular media. This could be a news item, could include a graph or chart, or could be a report on a poll. You cannot repeat a post made by another student. You must post the image, video, or link. (1 point)
Source: You must also include the source(s) of the data. (1 point)
Variable: Identify the variable(s) and whether they are discrete or continuous. (2 points)
The Problem: Based on your knowledge of statistics, research design, and scientific reporting, critically evaluate the claims made and/or the method of graphical representation. (You can refer to your textbook, and/or other scientific sources). Length: 1-2 sentences. (2 points)

Your comments (4 points)

You will need to thoughtfully comment on at least TWO posts made by other students in the class. You will only be able to comment AFTER you have made your own post.
Each comment is worth 2 points.
DO: These comments must reflect an understanding of statistical concepts you have learned in the course and contribute to the discussion of critically evaluating the data presented in the post. For example, this could include more accurate ways of presenting or interpreting the data. Length: 1-2 sentences per comment.
DON'T: You may NOT include personal or subjective comments directed towards another student or the instructor, or any personal, political or religious views that are disrespectful to others. Evaluate the content, not the source or person presenting the information. Please keep in mind that this is a scientific discussion of data we might encounter in our everyday lives. 

Before diving into your data, it's always best to first explore the dataset to understand what you are working with.

1. Considering that you will be combining your two tables of data together at a later stage, how many rows of data are available for your analysis?
   Hint: do headers count?

Enter Answer here

2. How are unknown values represented in the dataset?
   Answer here:
3. What is the salary range covered by this dataset?
   $254,000
   $200,000
   $235,500
   $238,500
4. How many unique industries are covered by the dataset?
   Hint: disregard the unknown values.
   59
   60
   58
   61
5. How many unique industries are covered by the dataset?
   Hint: disregard the unknown values.
   61
   60
   58
   59

6. Consider the following point from your boss's email:
   "Where do data scientists work?"
   In its current form, this question is ambiguous as it is unclear whether it is asking about the location where data scientists work or the industry in which they work.
   Think about how you could approach this question, how to best answer it, and how it could be phrased in data terms. Select the most correct option below.
7. What are locations and industries with the highest number (count) of data jobs?
8. What are the locations with the highest proportion (%) of data scientists relative to all data jobs?
9. What are the industries with the highest salary total (sum) for data scientists?
10. What are the locations and industries with the highest number (count) of data scientists?
11. What are the locations and industries with the highest salary total (sum) for data scientists?

7 Now you've explored your data and thought about how to define your questions, you can now transform the data to make it ready for analysis.
In the job_salary table, the job title and job category are currently given together in the Job Title (Job Category) column, e.g: Healthcare Data Scientist (data scientist).

For further analysis, you will need to separate the job title and job category into separate columns (as shown in the image below).
To create a dedicated Job Title column in your job_salary table, which of the following combinations of text manipulation functions could you use?
Note: the X in the formulae below represents the unseparated Job Title (Job Category) column..

=RIGHT(X,FIND(")", X))
=RIGHT(X,FIND(")", X)-1)
=LEFT(X,LEN(X)-FIND("(", X))
=LEFT(X,FIND("(", X)-1)
=LEFT(X,FIND("(", X))

8. Now create a dedicated Job Category column on your job_salary table and use text manipulation functions to split job category from the job title.
   Once you have done this, using your newly created job category column, answer the following to check that you have done this step correctly:
   How many data scientist, data engineer, and data analyst jobs (in that given order) are there?
   311, 123, 103
   109, 315, 119
   313, 119, 109
   319, 113, 109
   303, 119, 109
9. You will also need to join your two sheets of data together, the job_salary table and the company datasets.
   Which method(s) below could you use to join the datasets together? Select all correct answers.
   Use your method of choice to join the datasets together.
   Hint 1: Consider whether your datasets have an equal number of rows to each other.
   Hint 2: We recommend joining the company dataset onto the salary dataset.
   Manually copy the data from one table and insert onto the side of the other table
10. Manually copy the data from one table and insert it below the other table
11. Use INDEX/MATCH
12. Transform the data in both sheets into Tables and then use Excel Power Query to append the tables together
13. Transform the data in both sheets into Tables and then use Excel Power Query to merge Queries
14. There's no need to join the datasets together as you'll analyse each table separately
15. Use VLOOKUP
16. Now that you have consolidated your two tables of data together, answer the following question to check that you have correctly joined your data:
    What is the average salary of a Data Scientist (using your newly created Job Category column) in the Aerospace & Defense industry? Round your answer to the nearest whole number.
    Hint: remember that filters hide rows of data, but don't remove them. Ensure that your calculation only includes filtered cells and not the hidden cells.
    $110,679
    $66,344
    $128,302
    $63,658
    $123,816
    $120,294

The Excel data for this assignment is attached here.
Please find the file:- Dataset - Data Jobs_real_assgnt.xlsx

Note that we can also provide help for this assignment under the statistics assignment help customized services.

Graded Discussion: Solve Normal Distribution Application

For this graded discussion, you will be given a scenario to analyze using a cumulative from the mean z-table.
Requirements:

A minimum of two posts is required.
You must give a detailed solution for each part in your first post to get full credit.
It is not enough to just give the final answer. You must show steps or explain your reasoning.
If it is easier, you can write your solution out on paper, take a picture, and upload it to the discussion as a PDF file. The PDF file type is the only file type that will be accepted.
You will be able to see other students' posts once you post your own solution.
Review their responses to determine if they agree with your own.
For your second post, reply to a classmate to indicate if your answers are the same or different from theirs.
If they are different, explain which post you think is correct, yours or theirs.
If your original post was incorrect, reply to yourself with a correction. Don't worry! You will not lose points for an incorrect answer, as long as you make a reasonable effort at the first post and post a reply with the correct answer.
Complete required posts by the posted deadline.

Part 1: Prepare
Familiarize yourself with the following data.
In 1955, scientists R.R. Sokal and P.E. Hunter analyzed the affects of pesticides on houseflies. Among the data sets they collected were samples of housefly wing lengths. These are normally distributed. The data they collected is summarized in the following frequency distribution.

Normally Distributed

*Source: Sokal, R.R. and F.J. Rohlf, 1968. Biometry, Freeman Publishing Co., p 109. Original data from Sokal, R.R. and P.E. Hunter. 1955. A morphometric analysis of DDT-resistant and non-resistant housefly strains Ann. Entomol. Soc. Amer. 48: 499-507.
Part 2: First Post*

Answer these questions:

Find the mean and standard deviation of the sample of housefly wing lengths. (2 points)
List the data values that are within 2 standard deviations of the mean. Justify your answer. (2 points)
What percentage of the data values are within 2 standard deviations of the mean? (2 points)
Is this consistent with the Empirical Rule? Explain. (2 points)

Part 3: Second Post
For your second post, reply to a classmate to indicate if your answers are the same or different from theirs. If they are different, explain which post you think is correct, yours or theirs. (2 points)
If your original post was incorrect, reply to yourself with a correction. Don't worry! You will not lose points for an incorrect answer as long as you make a reasonable effort at the first post and post a reply with the correct answer.

Note that My Course Tutor can help you write this discussion posts under our statistics assignment help services. We have writing experts who are qualified to handle mathematics and statistics courses at all academic learning levels.

Probability Question Example
The following question is a probability question for tossing a fair coin presented in Pearson My STATLAB statistics. Note that probability concepts are the building blocks for any introductory statistics course. To solve the problem, one would have to write down the possible outcomes, and associate each outcome with some probabilities.
Two fair coins are tossed​ (say a dime and a​ quarter). The two possible outcomes for a single coin are​ heads, h, and​ tails, t. Give each of the following.
​(a) the sample space
​(b) the probability of heads on the dime
​(c) the probability of heads on the quarter
​(d) the probability of getting both heads
​(e) the probability of getting the same outcome on both coins

Deliverable 7 - Statistical Analysis Report item options Assignment Content

Competencies

Describe the data using the measures of central tendency and measures of variability.
Apply the normal distribution, standard normal distribution, and central limit theorem.
Develop a confidence interval for a population parameter.
Evaluate hypothesis tests for population parameters from one population.
Evaluate hypothesis tests for population parameters from two populations.
Determine the linear correlation and regression equation between two variables to make predictions for the dependent variable.

Student Success Criteria
View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.

Instructions
You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past few days, you have noticed an increase in patients admitted with a particular infectious disease. You believe that the ages of these patients play a critical role in the method used to treat the patients. You decide to speak to your manager, and together you work to use statistical analysis to look more closely at the ages of these patients.

You do some research and put together a spreadsheet of the data that contains the following information
Client number
Infection disease status
Age of the patient

Deliverable 7 - Statistical Analysis Report.xlsx

You are to put together a PowerPoint presentation that explains the analysis of your findings which you will submit to your manager. The presentation should contain all components of your findings. For review, the components of the report should include:

Brief overview of the scenario and variables in the data set
Discussion, calculation, and interpretation of the mean, median, mode, range, standard deviation, and variance
Discussion, construction, and interpretation of the 95% confidence interval
Explanation of the full hypothesis test
Conclusion

The calculations should be performed in your spreadsheet that you will also submit to your manager. You can find additional information on what to add to your PowerPoint presentation in this Word document.

Deliverable 7 - PowerPoint Instructions.docx

Use the questions in the Word document as your guide for the contents of your presentation.

For your final deliverable, submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document.