QUESTION 2 [20] For Question 2, all graphs should contain suitable headings and you should label all axes clearly. Consi
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
QUESTION 2 [20] For Question 2, all graphs should contain suitable headings and you should label all axes clearly. Consi
QUESTION 2 [20] For Question 2, all graphs should contain suitable headings and you should label all axes clearly. Consider the data set below: Job Number 39 Items Beds Quantity to be moved 128 | 40 41 166 178 Tables Chairs Couches Stoves 42 153 118 43 2.1 Summarise the 'Items' column by using a pivot table in Excel. Display the results using a pie chart. Include a copy of your pivot table with your simple bar chart. (8) 2.2 Summarise the 'Quantity to be moved' column using the Histogram function from the Data Analysis tool in Excel. Display the results using a histogram using suitable intervals of your choice. Include a copy of your frequency table with your histogram. (12)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!