Answer should be in excel file please help

QBA 241/MTH101/MTH195 Quantitative Business Analysis / Statistics / Applied Statistics SU-2, 2020 Final Lab Project #3 (20 points) The project is individual. You are required to complete this lab project based on the provided data. You have to discuss and appraise the given project. You must submit soft copy of the Excel file with your lab project on the Moodle (MyCUD) no later than 23:59, 10th of August 2020. All solution along with Student Name, ID Number, Course Name/Code, Faculty Name should be placed on one page of the Excel file. The project submitted after the deadline will be graded out of 10.0 points. Final Lab Project Question 1. Public Opinion reported that 5% of Americans are afraid of being alone in a house at night. If a random sample of 20 Americans is selected, find the probabilities by using =BINOMDIST () function in the Excel. 1. There are exactly 6 people in the sample who are afraid of being alone at night. (1 point) 2. There are exactly 11 people in the sample who are afraid of being alone at night. (1 point) 3. There are at most 4 people in the sample who are afraid of being alone at night. (1 point) 4. There are at least 7 people in the sample who are afraid of being alone at night. (1 point) 5. Fewer than 3 people in the sample who are afraid of being alone at night. (1 point) 6. Between 2 and 10 people inclusively in the sample who are afraid of being alone at night. (1 point) 7. How many people who are afraid of being alone at night would you expect to find in a sample of 20? (1 point) 8. Find the variance and standard deviation. (1 point) Question 2. The number of visitors to the Railroad Museum during 24 randomly selected hours is shown below. 67 62 38 73 34 43 72 35 53 55 58 63 47 42 51 62 32 29 47 62 29 38 36 41 9. Calculate mean, median, mode, and standard deviation to describe the data of collected data using Data>Data Analysis>Descriptive Statistics. Make precise interpretations of each statistical measure in Text Box (Insert>Text Box). (2 points) 10. Calculate first, second and third quartiles for the data above (Q1, Q2, Q3, Excel: =QUARTILE()) and interquartile range (IQR=Q3-Q1). Make precise interpretations of each statistical measure. (2.0 points) 11. Construct a stem and leaf plot for the data. (1 point) 12. Fill the table below for 5 classes (2 points) Class limits Frequency Relative frequency Cumulative frequency 13. Describe the data from the table above. (2 points) 14. Draw the pie chart for the relative frequency in %. (1 point) 15. Draw histogram using the frequency and corresponding class limits. Describe describe modality, skewness, and kurtosis of the data. (2 points)