Question: please help solving using excel formulas excel B D E F G H 8 Steps to Perform: 9 Points 10 Step Instructions Possible 11 Start

please help solving using excel formulas excel

H 8 Steps to Perform: 9 Points 10 Step Instructions Possible 11

Start Excel. Download and open the workbook named: 0 12 1 Describing_Data_B_Displaying_Qualitative_Data_Start

13 2 What type of data is the sales in column B

on the Data sheet? Choose your answer from the dropdown menu in

B D E F G H 8 Steps to Perform: 9 Points 10 Step Instructions Possible 11 Start Excel. Download and open the workbook named: 0 12 1 Describing_Data_B_Displaying_Qualitative_Data_Start 13 2 What type of data is the sales in column B on the Data sheet? Choose your answer from the dropdown menu in cell H3 7 14 In cells C7:C14, find the frequency of the number of people per social media platform. 15 3 7 16 Hint: use the COUNTIF function. 17 In cell C15, find the sum of all frequencies. 7 18 In cells C18:C25, construct a relative frequency distribution 7 19 6 In cells D18:D25, construct a cumulative frequency distribution. 7 7 Highlight the frequency distribution table in cells B6:C14 and select the Insert tab and the Insert Column or Bar Chart icon. Click on the first 2-D Column icon. Move the column chart and resize it to fit in the range 20 B27:D39. Change the chart title to Social Media Platforms Column Chart. 8 8 Highlight the frequency distribution table in cells B6:C14 and select the Insert tab and the Insert Column or Bar Chart icon. Click on the first 2-D Bar icon. Move the bar chart and resize it to fit in the range B41:D53. 21 Change the chart title to Social Media Platforms Bar Chart. > 22 9 Based on this sample data, determine the most popular platform. Choose your answer from the dropdown menu in cell H54. 7 23 10 Based on this sample data, determine the second most popular platform. Choose your answer from the dropdown menu in cell H55. 7 24 11 Based on this sample data, determine the third most popular platform. Choose your answer from the dropdown menu in cell H56. 7 25 12 Based on this sample data, determine the least popular platform. Choose your answer from the dropdown menu in cell H57. 7 26 13 In cell H58, find the percentage of people who preferred "Twitter" in this sample. 7 Highlight the frequency distribution table in cells B6:C14 and select the Insert tab and the Insert Pie icon. Click on the first 2-D Pie icon. Move the pie chart and resize it to fit in the range B60:D74. Change the chart title 8 27 14 to Social Media Platforms Pie Chart. Under the Design tab, change the chart style to Style 3 15 Copy and paste the pie chart in the range B76:D90. Double-click on the biggest slice (most popular platform) and from the Format Data Point window on the right side of the screen, under the Series Options, change the Point Explosion to 10%. 7 28 29 16 Save your file and submit for grading. 0 30 Total Score 100 31 32 33 34Excel File Edit View Insert Format Tools Data Window Help AutoSave ON 3 5 - 5 94% Sat 1:41 PM crichton excel 1(2) - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Times New Roman 12 A A D Wrap Text v General Paste BIUV MVAv AYO. Merge & Center v $ ~ % 9 Conditional Format Cell Insert ormatting as Table Styles Delete Format Sort & Find 8 Ideas Filter Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No G17 Jx G H M Student Social Media Platform V W AA AB Google ouTube Snapchat ou Tube Twitter Snapchat Whatsapp Twitter YouTube 11 Facebook 12 Pinterest 13 12 Snapchat 14 13 Whatsapp 15 14 Facebook 16 15 facebook 17 16 Facebook 18 17 Thatsapp 19 Snapchat 20 19 Snapchat 21 20 You Tube 22 21 Twitter 23 22 Whatsapp 24 23 Whatsapp 25 napchat 26 2 stagram 27 Facebook 18 127 Instagram Instructions Data Questions + Select destination and press ENTER or choose Paste 88% SEP 19 W X 553 726 EGGS MAXExcel File Edit View Insert Format Tools Data Window Help 94% Sat 1:41 PM AutoSave ON 3 5 - 5 crichton excel 1(2) - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Times New Roman 12 A A D Wrap Text v General AYO. Paste BIUV MVAv Merge & Center v $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find 8 Ideas ormatting as Table Styles Filter Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No G17 fx G M W AA AB 8 nstagram 28 Twitter 29 Pinterest 130 ou Tube 32 31 Facebook 33 32 Instagram 34 33 Snapchat 35 34 Whatsapp 135 Twitter 136 instagram 37 Google+ 38 You Tube 139 Twitter 140 Facebook 41 Twitter 142 Facebook 143 Snapchat 144 Instagram Snapchat 46 Twitter 47 Twitter 49 148 Snapchat 50 149 Snapchat 50 Facebook 52 Twitter 53 52 Whatsapp 54 153 Facebook 55 54 Facebook Instructions Data Questions + Select destination and press ENTER or choose Paste + 88% SEP 19 W X $53 726 EGGSExcel File Edit View Insert Format Tools Data Window Help 94% Sat 1:41 PM AutoSave ON 3 5 - 5 crichton excel 1(2) - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Times New Roman 12 A A D Wrap Text v General AYO. Paste BIUV - v VAv Merge & Center v $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find 8 Ideas ormatting as Table Styles Filter Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No G17 fx G M Q V AA AB 56 wnaisapp w 57 56 Snapchat 58 57 Snapchat 59 58 Facebook 60 159 Twitter 61 160 Snapchat 61 Google+ 62 Snapchat 163 YouTube acebook toogle 8 9 66 Facebook 167 napchat 69 168 Whatsapp 169 Google+ 70 Pinterest 71 Whatsapp YouTube 74 173 Snapchat 75 74 Twitter 76 75 Whatsapp 76 Instagram 177 Twitter 178 Facebook 80 79 Twitter 80 acebook 181 Pinterest 182 Snapchat Instructions Data Questions + Select destination and press ENTER or choose Paste + 88% SEP 19 C W X $53 726 EGGS MAXExcel File Edit View Insert Format Tools Data Window Help 93% Sat 1:44 PM AutoSave ON 3 5 - 5 crichton excel 1(2) - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Times New Roman 12 A A D Wrap Text v General AY- O. Paste BIUV MVAv Merge & Center v $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find 8 Ideas ormatting as Table Styles Filter Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No G17 fx B G M W AA AB 76 Whatsapp 8 60 76 stagram 177 Twitter 178 acebook 79 Twitter 81 80 Facebook 82 Pinterest 83 182 Snapchat 84 83 Facebook 85 84 facebook 86 85 Whatsapp 87 186 Twitter Facebook 89 88 Whatsapp 189 90 8 Facebook 91 190 Whatsapp 100 101 102 103 Instructions Data Questions + Select destination and press ENTER or choose Paste 88% SEP 19 W X 553 726 EGGS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Please answer those green box questions. A B D E F G H 1 J L M N Req. 1: Enter 160 for the number of filing cabinets ordered in the green cell on the left. The customer margin under activity based...

These are screenshots of the workbook. These are the instructions. Please solve step by step with screenshots! AutoSave OFF BESU- Page Layout Formulas Cooper_Exp 19_Excel_Ch07_CapAssess Data Review...

WHAT IT SHOULD END UP LOOKING LIKE: EXCEL GIVEN BELOW: Exp19_Excel_Ch08_Cap_Golden_State_5K Project Description: You are a volunteer for the Golden State 5k, an annual 5k held across several cities...

A B D E F G H J K L 1 Nm Account Number Last Name 367459 Hyat First Name Kato 4 5 Standard Deviation 6 7 Frequency of Occurrence $ 20.00 $ 40.00 $ 60.00 $ 80.00 $ 100.00 Variance 8 9 10 11 12 13 14...

I need major help entering the answers in excel formula on excel Jx A B D E F G H 1 K L M Data Section: Percent Conversion 40% Units 60,000 210,000 30,000 Work in process, beginning Units completed...

Aleeta Hecciatt, manager of the Red Bluff Pro Shop, would like to develop a marketing strategy for increasing pro shop patronage. She has requested data about the pro shop sales over the past several...

p B D E F G H 1 K L M N P 1 3-Year Balance Sheet 2 Expenses (Without Payroll and Cost of Sales) S $5,000 $10,000 $15,000 $20,000 3 $25,000 4 Advertising 5 Education & Training 6 7 Insurance $450,000...

Please show in Excel. Thank You! B D E F G H 1 Problem 9-30 2 3 After spending $10,000 on client development, you have just been offered a big production contract by a new client. The contract will...

YO_Excel16_Ch02_PS2_v3 Project Description: Roger Harding, the manager of Thunder City Bookstore, wants to improve the appearance of the workbook created to review the store inventory. Roger has a...

Exp19_Excel_Ch07_Cap_Real_Estate Project Description: You are the office manager for a real estate company in northern Utah County. You tracked real estate listings, including city, agent, listing...

When a second-order linear homogeneous differential equation is written in the form (2.3), any point at which P(x) or Q(x) becomes infinite is called a singular point or singularity. In solving a...

For each of the following acid/ base titrations, calculate the H3O+ and OH2 concentrations at equivalence and at titrant volumes corresponding to 20.00 mL, 10.00 mL, and 61.00 mL of equivalence....

The practice of buying goods and services now and paying for them later is called Blank _ _ _ _ _ _ . Multiple choice question. factoring trade credit pledging revolving credit

WACC The Patrick Company's year-end balance sheet is shown below. Its cost of common equity is 18%, its before-tax cost of debt is 11%, and its marginal tax rate is 40%. Assume that the firm's...