Assignment

Answer any 2 questions. Show your workings using excel spreadsheets. This assignment is graded on workings, not your answers only. DUE ON OR BEFORE 06/18/2020 @ 11:59 pm.

QUESTION 1

Week 1 2 3 4 5 Saturday 50 49 52 45 56 Sunday 54 57 53 48 55 You recently started selling hot-dogs over the weekends. After observing sales for 5 weeks you got the number of hot-dogs sold each weekend above. a. Compute the mean sales on Saturdays and Sundays. b. Compute sample variances of sales on Saturdays and Sundays. c. What is the value of the test statistic used for testing the hypothesis that the sales are the same on Saturdays and Sundays? d. What is the value of the test statistic used for testing the hypothesis that the sales on Saturdays are on average 5 hot-dogs bigger than the sales on Sundays?

QUESTION 2

4. As a manager, you want to know how likely is it that somebody who enters the store will purchase something. You asked one of your employees to check how many of the people who come to the store buy something. During one afternoon out of 210 people who entered the store 70 actually bought something. a. Find the sample probability of purchase or the expected mean of probability. b. Find 90% confidence interval for the sample probability of purchase. c. Find 95% confidence interval for the sample probability of purchase. d. Find 99% confidence interval for the sample probability of purchase. e. Which of those confidence intervals is the widest and why?

QUESTION 3

HANDSOAP PAPER TOWEL 1 253 281 2 267 288 3 258 286 4 269 273 5 250 273 6 253 288 7 269 284 8 267 279 9 266 279 10 269 283 The above data shows the number of handsoaps and paper towels sold in 10 days of the COVID-19 pandemic in a small town of 1000 people. 1. Determine the correlation coefficient between the product sales 2. Determine the regression or linear equation using handsoap as the INDEPENDENT variable. E.g letter X 3. Find the MEAN, MEDIAN, VARIANCE, AND STANDARD DEVIATION of the handsoap and paper towel. 4. What conclusion can you draw from your calculations?