A statistics professor has just given a final examination in…
A statistics professor has just given a final examination in his statistical inference course. He is particularly interested in learning how all students who took the course this semester performed. He has the following grades from his class of 40 student’s performance on the exam. The scores are shown below. You may copy and paste the table directly into Excel for calculations. 77 81 74 77 79 73 80 85 86 73 83 84 81 73 75 91 76 77 95 76 90 85 92 84 81 64 75 90 78 78 82 78 86 86 82 70 76 78 72 93 What is the standard deviation on this exam? Round your answer to two decimals.
Read DetailsCreate a new column called ‘Distributor New’ using these rul…
Create a new column called ‘Distributor New’ using these rules: If a movie’s distributor has released at least 30 movies in the dataset, list the original distributor name. If a movie’s distributor has released fewer than 30 movies, list ‘Other’. If the distributor field is blank/missing, also list ‘Other’. Steps to complete this task: First, create a lookup/reference table showing each distributor and their individual movie count. Then use a nested function formula combining to populate the ‘Distributor New’ column. The Distributor New for Waterworld is:
Read Details