Congratulations! You have completed the second exam. Please…

Congratulations! You have completed the second exam. Please upload your scratch paper with the work for your free response problems using the Exam 2 Upload link in Canvas within 15 minutes of submitting this exam. Make sure your work is labeled with the proper free response question number. Circle your final answers and include units. These answers must match the answers you submitted above.   Upload all work in ONE PDF or JPEG file.  

Please ensure that your camera is set up to show your worksp…

Please ensure that your camera is set up to show your workspace and your face. At this time show the front and back of your scratch paper, periodic table, and naming compounds and solubility rules chart to the camera so I can see that they are not written on. Show your calculator so I can see the type of calculator you are using. Please keep your hands visible in the camera. I understand that they may be out of view when reaching to move to the next question or to use the online calculator but please keep them above the table and do not reach off to the sides.  Now answer the following true or false question to earn a bonus point: I have done the above requirements, read the exam and Honorlock instructions, and understand that failure to follow all instructions will result in a zero on my exam. 

For this question, please download the provided Excel file c…

For this question, please download the provided Excel file containing the raw data. Your final answer should be entered directly below in the answer box. While you do not need to submit the Excel file itself, your step-by-step work in Excel must be clearly visible on your screen recording. I will review the recorded video of your screen to assign partial credit based on your problem-solving process.Q. A hotel manager is concerned about the number of late arrivals among front-desk employees. The attached Excel file, Q22 (v.4).xlsx, reports the number of times each of 12 employees arrived late during the last two-week work period. Construct a 95% confidence interval for the population mean number of late arrivals. Assume that the population distribution is normal.(Round your answer to 4 decimal places.)

Suppose a city mayor wants to estimate the proportion of res…

Suppose a city mayor wants to estimate the proportion of residents who support a new public transportation plan. The mayor wants the margin of error to be 0.07. Assume a 90% level of confidence. How large of a sample would be necessary if no estimate were available for the proportion of residents supporting the plan?