Solution_Describing_Data_B_Displaying_Qualitative_Data_Start

Descri Project D Steps to P Step 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 The prese relative fr We will us Use a cell full credit

ibing Data B Displaying Qualitative Data Description: Perform: Instructions Start Excel. Download and open the workbook named: Describing_Data_B_Displaying_Qualitative_Data_Start In cells C7:C14, find the frequency of the number of people per social media platform. Hint: use the COUNTIF function. In cell C15, find the sum of all frequencies. In cells C18:C25, construct a relative frequency distribution. In cells D18:D25, construct a cumulative frequency distribution. Based on this sample data, determine the most popular platform. Choose your answer from the dropdown menu in cell H54. Based on this sample data, determine the second most popular platform. Choose your answer from the dropdown menu in c Based on this sample data, determine the third most popular platform. Choose your answer from the dropdown menu in cell Based on this sample data, determine the least popular platform. Choose your answer from the dropdown menu in cell H57. In cell H58, find the percentage of people who preferred "Twitter" in this sample. Save your file and submit for grading. ent study shows data for the social media platform preferred by a sample of 90 people between the age of 18-45 requency distribution, and a cumulative frequency distribution. We will use Excel functions to sum up the data. se cell referencing to identify relative frequencies. We will use Excel charts to construct column, bar, and pie cha l reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or t for your answers. What type of data is the sales in column B on the Data sheet? Choose your answer from the dropdown menu in cell H3. Highlight the frequency distribution table in cells B6:C14 and select the Insert tab and the Insert Column or Bar Chart ico chart and resize it to fit in the range B27:D39. Change the chart title to Social Media Platforms Column Chart . Highlight the frequency distribution table in cells B6:C14 and select the Insert tab and the Insert Column or Bar Chart ico resize it to fit in the range B41:D53. Change the chart title to Social Media Platforms Bar Chart . Highlight the frequency distribution table in cells B6:C14 and select the Insert tab and the Insert Pie icon. Click on the first range B60:D74. Change the chart title to Social Media Platforms Pie Chart . Under the Design tab, change the chart styl Copy and paste the pie chart in the range B76:D90. Double-click on the biggest slice (most popular platform) and from the F under the Series Options , change the Point Explosion to 10% .

Student Social Media Platform 1 Google+ 2 YouTube 3 Snapchat 4 YouTube 5 Twitter 6 Snapchat 7 Whatsapp 8 Twitter 9 YouTube 10 Facebook 11 Pinterest 12 Snapchat 13 Whatsapp 14 Facebook 15 Facebook 16 Facebook 17 Whatsapp 18 Snapchat 19 Snapchat 20 YouTube 21 Twitter 22 Whatsapp 23 Whatsapp 24 Snapchat 25 Instagram 26 Facebook 27 Instagram 28 Twitter

29 Pinterest 30 YouTube 31 Facebook 32 Instagram 33 Snapchat 34 Whatsapp 35 Twitter 36 Instagram 37 Google+ 38 YouTube 39 Twitter 40 Facebook 41 Twitter 42 Facebook 43 Snapchat 44 Instagram 45 Snapchat 46 Twitter 47 Twitter 48 Snapchat 49 Snapchat 50 Facebook 51 Twitter 52 Whatsapp 53 Facebook 54 Facebook 55 Whatsapp 56 Snapchat 57 Snapchat

87 Facebook 88 Whatsapp 89 Facebook 90 Whatsapp

Describing Data B Displaying Qualitative Data 1-2. What type of data is the sales in column B on the Data sheet? Choose your answer from 3. In cells C7:C14, find the frequency of the number of people per social media platform. 4. In cell C15, find the sum of all frequencies. Bin Frequency Google+ 5 YouTube 8 Snapchat 18 Twitter 15 Whatsapp 14 Facebook 20 Pinterest 4 Instagram 6 Total 90 5-6. In cells C18:C25, construct a relative frequency distribution. In cells D18:D25, constru Bin Relative Frequency Cumulative Relative Frequency Google+ 0.06 0.06 YouTube 0.09 0.14 Snapchat 0.20 0.34 Twitter 0.17 0.51 Whatsapp 0.16 0.67 Facebook 0.22 0.89 Pinterest 0.04 0.93 Instagram 0.07 1.00 7. Use a cell reference or a single formula where appropriate in order to receive full credit. receive full credit for your answers. Highlight the frequency distribution table in cells B6:C14 and select the Insert tab and column chart and resize it to fit in the range B27:D39. Change the chart title to Social M Google+ YouTube Snapchat Twitter Whatsapp Facebook Pinterest Instagram 0 5 10 15 20 25 Social Media Platforms Column Chart

6% 9% 20% 17% 16% 22% 4% 7% Social Media Platforms Pie Chart Google+ YouTube Snapchat Twitter Whatsapp Facebook Pinterest Instagram

m the dropdown menu in cell H3. Qualitative-Nominal uct a cumulative frequency distribution. Do not copy and paste values or type values, unless otherwise directed, as you will not the Insert Column or Bar Chart icon. Click on the first 2-D Column icon. Move the Media Platforms Column Chart .