Hello please help me with the statistics problem as I am very confused. I have attached the file with the audit times and well as what the table should look like after following the steps See attached file with Audit times Follow the instructions Step 1-8 and develop Figure 2.10 (second attachment) and then add relative frequency and cumulative frequency. Keep in mind that “count of audit time” is frequency only. Upload the final figure showing classes, frequency (count of audit time), relative frequency, and cumulative frequency.Step 1. Select any cell in the data set (cells A1:A21)Step 2. Click the Insert tab on the RibbonStep 3. In the Tables group click PivotTableStep 4. When the Create PivotTable dialog box appears: Click OK; a PivotTable and PivotTable Fields task pane will appear in a new worksheetStep 5. In the PivotTable Fields task pane: Drag Audit Time to the ROWS area Drag Audit Time to the VALUES areaStep 6. Click on Sum of Audit Time in the VALUES areaStep 7. Select Value Field Settings ... from the list of options that appearsStep 8. When the Value Field Settings dialog box appears: Under Summarize value field by, choose Count Click OK 123456789101112131415161718192021Audit Time1215202214141527211819182233161817232813 FIGURE 2.10 Frequency Distribution for the Audit Time Data ConstructedUsing Excel's Pivot Table ToolB123 Row Labels - Count of Audit Time4 10-145 15-196 20-247 25-298 30-349 Grand Total1011121314151617181920852120DPivotTable FieldsChoose fields to add to report:SearchAudit TimeMORE TABLES...Drag fields between areas below:T FILTERSROWSAudit TimeCOLUMNSΣ VALUESCount of Audit Time

Introduction: It is required to present the data in the suggested format, and obtain the relative…

Answered: Hello please help me with the…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Hello please help me with the statistics problem as I am very confused. I have attached the file with the audit times and well as what the table should look like after following the steps

See attached file with Audit times

Follow the instructions Step 1-8 and develop Figure 2.10 (second attachment) and then add relative frequency and cumulative frequency. Keep in mind that “count of audit time” is frequency only. Upload the final figure showing classes, frequency (count of audit time), relative frequency, and cumulative frequency.

Step 1. Select any cell in the data set (cells A1:A21)
Step 2. Click the Insert tab on the Ribbon
Step 3. In the Tables group click PivotTable
Step 4. When the Create PivotTable dialog box appears: Click OK; a PivotTable and PivotTable Fields task pane will appear in a new worksheet
Step 5. In the PivotTable Fields task pane: Drag Audit Time to the ROWS area Drag Audit Time to the VALUES area
Step 6. Click on Sum of Audit Time in the VALUES area
Step 7. Select Value Field Settings ... from the list of options that appears
Step 8. When the Value Field Settings dialog box appears: Under Summarize value field by, choose Count Click OK