Question: I need help learning the excel functions to figure out the answer. Test 1 Excel Home Insert Page Layout Formulas Data Review View Calibri (Body)
Test 1 Excel Home Insert Page Layout Formulas Data Review View Calibri (Body) 11 ' A-A+ wrap Test Paste s All answers to the following questons must show the use of the appropriate Excel function. No 6 a. Find the "Trequency distribution"(3 pts) hand calculations wil be accepted b Find the "relative frequency distribution. (3 pts) . Frd the "percent frequency distribuion" for the hustles (3 pts) d. Find the "cummulative frequency distrbution. (3 pts) 8 to e. Construct a pie chart using the Include a chart e and label each segment with the Industry and Percent (3 pts) . Construct a bar chart using the frequency distribution. Include a chart tte and appropriate axes lsbels. (3 pts) 12 Cummuative 16 Cable 17 Cable 18 Car s Collection 20 Cel 22 Col 23 Car 24 Bank 2s Cel 8 Bank 19 Cel o Cable 2 tab
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
