(a) State and describe two examples of how business analytics is used in organizations.    (b) What are the logical functions in Excel. Give a real world example where using a logical function is useful. (c) What is a line chart? What is a scatter diagram? What is the difference between a line chart and a scatter diagram? Give one real world example when using a line chart is appropriate and one real world example when using a scatter diagram is appropriate.    (d) Explain the basic concept of cause-and-effect modeling. Give a real world example when this approach is useful.    (e) Explain how the simple moving average method works in forecasting techniques. Give a real world example when this approach is useful.

Olivia attends school at the University of Alberta and decides to compile a contingency table of students who are taking various degrees. She surveys a group of students, and the data she collects is listed in the contingency table below. Olivia want to see if degree and gender are dependent variables. PhD Masters Undergraduate 22 74 62 ------+---+- Male 18 +---+ Female; 15: 25 -------- (a) In performing this statistical test, state the hypotheses. O Ho: The proportion of female students is the same as the proportion of male students vs. Ha: The proportion of female students is not the same as the proportion of male students O Ho: Degree is related to gender vs. Ha: Degree is not related to gender O Ho: Degree is associated with gender vs. Ha: Degree is not associated with gender O Ho: Degree and gender are dependent vs. Ha: Degree and gender are independent O Ho: Degree and gender are independent vs. Ha: Degree and gender are dependent (b) What is the expected frequencies of each…

Which situation below does NOT represent a multiplicative relationship?  a There are three times as many apples as bananas  b One-third of the students are boys in Mr. Rocha's class.  c The number of laptops purchased increases by 135 each month  d The amount Neha earns each hour is $15.00

3190 You're a data analyst for an insurance company. You want to make sure that your employer is not over-paying for car repairs. To investigate this, you bring 31 different cars to two different garages, Bubba's Hubcap Heaven and Repair, and Merle's Motor Shop. Some of the cars need lots of repairs. Some of the cars need very few. By taking each car to both shops, we can directly compare the two sets of prices.  Before running your analysis, be sure to look at the data file and verify that each car requires a different amount of repairs, and that prices in one shop are correlated with prices at the other shop. That is, they're in the same ballpark. The question is whether one tends to charge more, on average, than the other. Your task is to use Excel to test the research hypothesis that prices are different in the two shops; the null hypothesis is that prices are equal between the two shops. You test at the alpha = 0.10 significance level. What do you conclude? Are prices the same?…