1. Other
  2. Other
  3. please explain your answer...

Question: please explain your answer...

Question details
Please explain your answer.
HW 5: Using probability to find mean, standard deviation and construct a Gaussian curve Mandatory: 1,2 USE EXCEL TO DO THIS PROBLEM Phoenix Forgotten April 21) 1. When reading a report, most of the time, you will be given a probability. You should be able to convert probabilities into averages and standard deviation. The equations are as follow: 20 mean s(p(xi-x) standard deviation 123456789 10 The graph to your right is the IMDb movie rating for Phoenix Forgotten. if you need help, watch the video mean: Excel can be very useful in calculating these values Rating Value (x) Probability (p) 9% 596 11% 20% 19% 13% 796 3% 10 IMDb rating of Phoenix Forgotten (2017) 2. Construct, in excel, the data distribution and the gaussian fit for the data in problem An example on how to use the NORM.DIST(X, mean, st.dev, FALSE) 1. Data Gaussian Fit 25% Your result should look neat (see example) Elements: - Title, label, legend, tick marks -Data should be in bar graphs -Gaussian fit in connected dashes - There should be no lines in the inside (it clutters the graph) Answer: aussian fi
Problem (3,4), (5,6) and so on will be similar to question 1&2. Choose one of these movies Calculate mean, standard deviation, draw the graph and determine whether the gaussian distribution properly fit the data Source: htt fivethirtveight.com/features/al-gores-new-movie-exposes-the-big-flaw-in-online-movie-ratings An Inconvenient Sequel: Truth to Power July 28) Vengeance: A Love Story (March 27, U.K.) 40% 40% 30 30 20 10 20 10 1 2 3 4 5 6 7 89 10 1 2 3 45 6 789 10
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution