Home Chemistry Questions and Answers

Data analytics quizzes

Course

Subject
Chemistry

Category
Questions and Answers

Pages
88

Uploaded By
ATIPROS

Module 1 Quiz 1) The data set below shows annual healthcare expenditures for 192 countries. Create a histogram of the data using the bins provided in column D. From the Data menu, select Data Analysis, then select Histogram. The Input Range is B1:B193 and the Bin Range is D1:D37. You must check the Labels in first row box to ensure that the histogram’s axes are appropriately labeled. 2) Suppose you actually want to calculate the mean annual healthcare expenditures of the 192 countries. Which of the following Excel functions calculates the mean? SELECT ALL THAT APPLY. =MEAN(B2:B193) =MEAN(B2:B193) is not a function in Excel. =AVERAGE(B2:B193) correct =AVERAGE(B2:B193) calculates the mean of the annual healthcare expenditures. Note that another option is also correct. =MEDIAN(B2:B193) =MEDIAN(B2:B193) finds the median, or middle value, of the annual healthcare expenditures. =SUM(B2:B193)/192 correct =SUM(B2:B193)/192 calculates the sum of the annual healthcare expenditures and divides that sum by 192, the number of data points. This formula calculates the mean of the annual healthcare expenditures. Note that another option is also correct =MODE.SNGL(B2:B193) .=MODE.SNGL(B2:B193) finds the mode, or most common value, of the annual healthcare expenditures.
Read More

Preview 5 out of 88 Pages

Data_analytics_Quizzes.docx.pdf prev1730998727672cf1c79d76d.png

Download all 88 pages for $ 14.50

Reviews (0)

$ 14.50


Seller

Joined: 6 months ago

Document sold: 0

Reviews received
1
0
0
0
0

Send Message
Document Information
Buy Document

$14.50