Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please help with this? Please only answer if you 100% know the answer. Please respond asap. Question 3 Not yet saved Marked out

image text in transcribed

Can someone please help with this?

Please only answer if you 100% know the answer.

Please respond asap.

image text in transcribedimage text in transcribed
Question 3 Not yet saved Marked out of 6.00 V7 Flag question A nutritionist calculates the calories in 27 samples of kidney beans. Calories per 1009 canned kidney beans are recorded in Caloriesxlsx file. Use Excel to complete the following sample summary statistics. Type in each of the answers. Keep your answers to 3dp. 1. (1 mark) Mean = 2. (1 mark) Median = 3. (1 mark) Standard deviation = 4. (1 mark) Range = 5. (1 mark) Q1 = 6. (1 mark) Q3 = . AutoSave OCH {1' E E' a Calories Horne Insert Draw Page Layout Formulas Data Review >> Q Tell me lg Share CI Comments 1 v v E O v [ :I Conditional Formatting v v , 3 v @ Ll:l [D V A : 6 [7 Format as Table v E 6 Font Alignment Number Editing Analyse Q Cell Styles v Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you I... No A Y 1 kidney beans 2 99.192 3 100.388 4 98.375 5 99.411 6 97.538 7 97.613 8 97.328 9 99.964 10 96.227 11 98.861 12 97.15 13 98.328 14 97.578 15 101.165 16 98.438 17 100.015 18 97.249 19 98.653 I II 20 96.656 21 99.961 22 98.317 23 97.469 24 98.679 25 99.613 26 94.647 27 100.157 28 98.393 29 30 31 32 33 34

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Discrete Structures, Logic, And Computability

Authors: James L Hein

3rd Edition

1449615279, 9781449615277

More Books

Students also viewed these Mathematics questions