solved I’m working on a business question and need an explanation

I’m working on a business question and need an explanation and answer to help me learn.

1.The sheet “Elecmart” in the data file provides information on a sample of 400 customer orders during a period of several months for E-mart. The standard deviation of number of items in an order isAnswer (please round your answer to 2 decimal places).2.The sheet “Elecmart” in the data file provides information on a sample of 400 customer orders during a period of several months for E-mart. The coefficient of variation of amount spent for the most expensive item in an order isAnswer % (please round your answer to 2 decimal places).3.Health care issues are receiving much attention in both academic and political arenas. A sociologist recently conducted a survey of citizens over 60 years of age who have no private health insurance. The ages of 23 uninsured male and female senior citizens are given in the sheet named “Health care” in the excel fileThe range of age of uninsured male senior citizens is Answer years.4.The sheet “Elecmart” in the data file provides information on a sample of 400 customer orders during a period of several months for E-mart. The number of orders placed for the mode of the variable “Day” is Answer5.The sheet “Elecmart” in the data file provides information on a sample of 400 customer orders during a period of several months for E-mart. How many customers pay with other type of credit card on Saturday?Generate a pivot table to obtain the answer.6.The sheet “Elecmart” in the data file provides information on a sample of 400 customer orders during a period of several months for E-mart. The average of number of items in an order by a shopper who uses other type of credit card for the payment on Sunday isAnswer (please round your answer to 2 decimal places).Generate a pivot table to obtain the answer.7.Health care issues are receiving much attention in both academic and political arenas. A sociologist recently conducted a survey of citizens over 60 years of age who have no private health insurance. The ages of 23 uninsured male and female senior citizens are given in the sheet named “Health care” in the excel fileIdentify which of the following is the incorrect statement for female senior citizens.Select one:a.The second quartile is 73 years or age, so about half of the female senior citizens sampled are above 73 years of age.b.The first quartile is 67 years of age, so about one fourth of the female senior citizens sampled are between 61 to 67 years of age.c.The third quartile is 80 years of age, so about three fourth of the female senior citizens sampled are above 80 years of age.d.The interquartile range is 13 years of age, so the middle 50% of the senior citizens sampled are between 67 and 80 years of age.

Looking for an Assignment Help? Order a custom-written, plagiarism-free paper

Order Now