Question

Question 1. The average number of cereal calories is around 150. Create the column “Cereal Calories” in the New Workbook in Excel and Generate the data for 46 ready-to-eat cereals by using the following function: =RAND()*(Upper limit-Lower Limit)+Lower limit, where Lower limit -is 80 and Upper limit is 270. Copy and Paste special>Values in order to continue to work on the generated data. Make the format of values as a number without decimal places (Format Cells>Number)

Question 2. Construct a stem and leaf plot for the previously obtained data

Question 3. Create a frequency table with 7 classes. The table should have the following headings [Class limits] [Class boundaries] [Frequency] [Cumulative frequency]

Question 4. Describe the data from the table above.

Question 5. Add column “Relative frequency” to the table above, obtain relative frequency and draw a vertical bar chart to present the data

Question 6. Draw histogram, describe modality, skewness, and kurtosis of the data.

Question 7. Make a research and list 5 brands of cereals with calories (create a table). Discuss the impact of cereals in a daily nutrition

(Note: Please Solve on excel file and share excel file instead of pic please please help me in this i,m struggling hardly good reviews will be given with Thanks)

Answer 1

Q.2) Stem and leaf plot-

The decimal point is 1 digit(s) to the right of the |
   8 | 146238
  10 | 90
  12 | 05167
  14 | 14574
  16 | 268823
  18 | 46227
  20 | 378935
  22 | 5899
  24 | 144824
  26 | 2

Q.3)

Class limit	Class boundary	Frequency	Cumulative frequency	Relative frequency
0-89	59.5-89.5	3	3	0.065
90-119	89.5-119.5	5	8	0.109
120-149	119.5-149.5	9	17	0.196
150-179	149.5-179.5	7	24	0.152
180-209	179.5-209.5	9	33	0.196
210-239	209.5-239.5	6	39	0.130
240-269	239.5-269.5	7	46 = N	0.152

Q.6) Histogram

Descriptive statistics
Mean	174.86957
Standard Deviation (s)	54.00766
Skewness	-0.11768
Kurtosis	-1.13145
Lowest Score	81
Highest Score	262
Distribution Range	181
Total Number of Scores	46
Number of Distinct Scores	42
Lowest Class Value	60
Highest Class Value	269
Number of Classes	7
Class Range	30

Q.7)

Cereals are staple foods, and are important sources of nutrients in both developed and developing countries. Cereals and cereal products are an important source of energy, carbohydrate, protein and fibre, as well as containing a range of micronutrients such as vitamin E, some of the B vitamins, magnesium and zinc.