Submitted in PDF format only. Do not submit Excel spreadsheets or datasets. Respond in complete sentences. Please format to APA expectations for all charts and tables that you generate or are generated in Excel.
Directions: Examine the attached datasets for this assignment.
For Dataset 1: This dataset consists of the number of customers, who entered a business establishment, on a particular day each quarter. That is, one day was selected at the start of each quarter to count the number of customers who entered a business establishment
1) Reference control chart notes and Excel workbook attached to Moodle
1) Using Excel, Design a p-chart control chart spreadsheet based on the process data in this dataset
2) In your submission, Report your data table containing the proportions and your p-chart
4) Interpret the chart and discussion in your interpretation regarding the quality of the process. Explain
5) Can a times series analysis be used over this dataset? Explain.