Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Could you please show me step by step how to work this out and how to create the table on excel A B C D
Could you please show me step by step how to work this out and how to create the table on excel
A B C D E F G H | J K L M One of the issues with making consistent Hazelnut Spread is that batches of hazelnuts vary in the amount of fat that they contain. Consequently every batch of hazelnuts purchased by the maufacturers of Nutella has to be analysed for fat content. Below are the results of analysis over 12 months of manufacture. Create an appropriate frequency table and 1 produce a properly labelled histogram to display the results. You should use a bin size of 0.5g. 2 Measurement: grams of fat per 100grams of nuts 3 4 23.82 23.37 22.34 22.37 24.94 19.00 22.36 21.02 22.58 22.92 18.13 21.84 5 17.42 22.02 23.55 24.63 22.27 24.79 22.13 20.05 19.68 22.63 22.93 22.60 6 21.70 23.03 21.52 22.23 22.40 23.14 21.88 23.13 24.63 20.66 20.04 25.17 7 18.68 19.91 22.20 22.84 19.51 24.39 22.76 22.49 19.75 20.56 20.27 20.09 8 20.41 22.01 24.84 20.63 19.86 23.25 23.14 24.68 21.95 22.08 21.37 21.26 9 25.46 21.99 20.04 24.71 20.81 23.15 20.92 22.75 22.09 20.15 19.65 21.64 10 22.99 18.53 22.35 17.59 22.63 22.96 23.98 24.91 18.96 22.95 22.76 22.52 11 23.25 21.00 20.01 25.31 22.19 22.65 18.86 20.28 22.46 24.96 25.03 18.38 12 22.81 19.02 21.73 24.19 21.97 23.34 22.03 21.28 20.80 20.17 19.23 20.13 13 17.96 20.72 22.67 21.74 25.00 22.37 22.27 20.21 23.18 20.18 22.67 20.64Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started