excel 4 questions with document attached

Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it. Our writers will complete your order from scratch and make sure it’s completely unique.

Order a Similar Paper Order a Different Paper

  1. Your college or university wishes to obtain reliable information about student perceptions of administrative communication. Describe how to design a sampling plan for this situation based on your knowledge of the structure and organization of your college or university. How would you implement simple random sampling, stratified sampling, and cluster sampling for this study? What would be the pros and cons of using each of these methods?
  2. Number the rows in the Excel file Credit Risk Data to identify each record. The bank wants to sample from this database to conduct a more-detailed audit. Use the Excel Sampling tool to find a simple random sample of 20 unique records.

6.6 In determining automobile mileage ratings, it was found that the mpg in the city for a certain model is normally distributed, with a mean of 30 mpg and a standard deviation of 1.0 mpg. Suppose that the car manufacturer samples 5 cars from its assembly line and tests them for mileage ratings.

  1. What is the distribution of the mean mpg for the sample?
  2. What is the probability that the sample mean will be greater than 31 mpg?
  3. What is the probability that the sample mean will be less than 29.5 mpg?

6.11 A bank sampled its customers to determine the proportion of customers who use their debit card at least once each month. A sample of 50 customers found that only 12 use their debit card monthly. Find 95% and 99% confidence intervals for the proportion of customers who use their debit card monthly. Use the appropriate formula and verify your result using the Confidence Intervals workbook.


Do you need help with this or a different assignment? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.

Order a Similar Paper Order a Different Paper