Question 1.
a. What is the average rating for all CBC movies? How about ABN movies and BBS movies?
b. Include a table that shows the average and the other descriptive statistics (using the data analysis tool pack in Excel) for the ratings of the three networks (one column for each network). Explain what you learn from each of the metrics in the table.
c. Comment on which network is doing best.
Homework Answers
Add Answer to:
Question 1.
a. What is the average rating for all CBC movies? How about ABN
movies...
Using Excel, calculate the mean, standard deviation, standard error, median, sample variance, kurtosis, skewness, range, minimum,...
Using Excel, calculate the mean, standard deviation, standard error, median, sample variance, kurtosis, skewness, range, minimum, maximum, sum, count, largest(1), smaller(1) of your distribution and interpret their meanings. Column Mean Standard error Median Mode Standard Deviation Sample variance Kurtosis Skewness Range Minimum Maximum Sum Count Largest(1) Smallest(1)
What is the probability of 4 programs raise their daily active customers? 30% is the probability...
What is the probability of 4 programs raise their daily active customers? 30% is the probability of raising target customer? Total number of programs are 9 daily active users Mean Standard Error 54.79506 Median Mode Standard Deviation Sample Variance 27022.49 Kurtosis Skewness Range Minimum Maximum Sum Count 100.97 25 #N/A 164.39 4.89945 2.17118 499 500 908.75
Choose one answer for the purple blanks, answer number for orange blanks Thanks! Place Engine Size...
Choose one answer for the purple blanks, answer number for
orange blanks
Thanks!
Place Engine Size output (starting with label) in E2 -> EngncSIzC Place Hwy Fuel Eff output (starting with labe) in H2-> Hwy Fuci Effcicncy .155 0.0855 3.1558 .0857 0.7151 Mean -> Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Mcan -> Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Vlaximium Sum 34.2714 .0863 34.5000 7.0000 9.0888 0.6958 0.0122 1.3757 0.1782...
Describe one or two general observations you can make about variable X from these results. In...
Describe one or two general observations you can make about
variable X from these results. In particular, discuss how you would
interpret the Kurtosis and Skewness values based on your reading in
Lane or Devore (or any additional web search you might do on those
topics).
**(IT HAS TO BE BETWEEN 100-200 WORDS)
The results are in the photo
Columnil Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 97.39902873 2.235602503 95.64542122 11.17801251...
16. Over the last 12 months, monthly returns (%) were tracked for 3 stocks. Stock A...
16. Over the last 12 months, monthly returns (%) were tracked for 3 stocks. Stock A Stock B Stock C Mean 1.541666667 Mean 1.358333333 Mean 1.716666667 Standard Error 0.416052578 Standard Error 0.279734271 Standard Error 0.340361513 Median 1.5 Median 1.5 Median 2.3 Mode 2 Mode 2 Mode 0.35 Standard 1.041248407 Standard 0.969027942 Standard 1.179046867 Deviation Deviation Deviation Kurtosis -1.201149924 Kurtosis 4.043909504 Kurtosis -1.143448808 Skewness 0.449006632 Skewness -1.820993711 Skewness -0.610888303 Range 4 Range 3.5 Range 3.4 O A. Stock A O B....
Part B: Case Heavenly Chocolates Website Transaction Heavenly Chocolates manufactures and sells quality chocolate produ...
Part B: Case Heavenly Chocolates Website Transaction Heavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago the company developed a website and began selling its products. A sample of 50 Heavenly Chocolates transactions was selected from the previous month's sales The following shows the Excel output for the "Time (min)" variable (time spent the shoppers on the website), the "Page Viewed" (the number of website viewed),...
11] The Excel output on GPA below was generated from a sample of 30 students in...
11] The Excel output on GPA below was generated from a sample of 30 students in Stats II using the descriptive statistics function in Excel. These are all sample statistics. What is the upper bound to the 95% confidence interval around the mean? n 30 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum 2.943666667 0.09068004 2.84 2.5 0.496675037 0.246686092 1.011303207 0.36205901 1.74 2.17 3.91 88.31 30 0.185461504 a. 2.978 b. 3.129 C. 3.341 d. 2.873...
I just need help on questions 7 and 8 The U.S. Department of Energy's Fuel Economy...
I just need help on questions 7 and 8
The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks. (See exercise 35 on page 77 in your textbook for a similar problem.) Use the data in the FuelData sheet in this workbook to generate excel output to answer the following questions. Please note that units are "liters" for engine size and "miles per gallon" for highway fuel efficiency. Put the output in given space...
02. 1. Complete the Six Step Process (SSP) as defined Step Process (Version 1)," the Ch....
02. 1. Complete the Six Step Process (SSP) as defined Step Process (Version 1)," the Ch. 9 & 10 PPT slides and the Wk. 3 SG. You should note that I ha inseited background information and additional notes related to the case within the Excel worksheet in the reference titled"Hypothesis Testing the Six You will need to submit an Excel file containing your statistical output plus a Word document that contains all of your discussion points related to each step...
Summary of Descriptive Statistics Excel will tabulate a summary of the descriptive statistics for...
Summary of Descriptive Statistics Excel will tabulate a summary of the descriptive statistics for central tendency and using the Data Analysis Pack. Click Data Click Data Analysis .In the pop-up list click on Descriptive Statistics and hit OK . In the pop-up box in the input range type A2:A75 or highlight this region . Click the box next to summary statistics Click OK A box of summary statistics will appear like the one below Mean Standard Error Median Mode Standard...
What is the probability of 4 programs raise their daily active customers? 30% is the probability of raising target customer? Total number of programs are 9 daily active users Mean Standard Error 54.79506 Median Mode Standard Deviation Sample Variance 27022.49 Kurtosis Skewness Range Minimum Maximum Sum Count 100.97 25 #N/A 164.39 4.89945 2.17118 499 500 908.75
Choose one answer for the purple blanks, answer number for
orange blanks
Thanks!
Place Engine Size output (starting with label) in E2 -> EngncSIzC Place Hwy Fuel Eff output (starting with labe) in H2-> Hwy Fuci Effcicncy .155 0.0855 3.1558 .0857 0.7151 Mean -> Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Mcan -> Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Vlaximium Sum 34.2714 .0863 34.5000 7.0000 9.0888 0.6958 0.0122 1.3757 0.1782...
Describe one or two general observations you can make about
variable X from these results. In particular, discuss how you would
interpret the Kurtosis and Skewness values based on your reading in
Lane or Devore (or any additional web search you might do on those
topics).
**(IT HAS TO BE BETWEEN 100-200 WORDS)
The results are in the photo
Columnil Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 97.39902873 2.235602503 95.64542122 11.17801251...
16. Over the last 12 months, monthly returns (%) were tracked for 3 stocks. Stock A Stock B Stock C Mean 1.541666667 Mean 1.358333333 Mean 1.716666667 Standard Error 0.416052578 Standard Error 0.279734271 Standard Error 0.340361513 Median 1.5 Median 1.5 Median 2.3 Mode 2 Mode 2 Mode 0.35 Standard 1.041248407 Standard 0.969027942 Standard 1.179046867 Deviation Deviation Deviation Kurtosis -1.201149924 Kurtosis 4.043909504 Kurtosis -1.143448808 Skewness 0.449006632 Skewness -1.820993711 Skewness -0.610888303 Range 4 Range 3.5 Range 3.4 O A. Stock A O B....
Part B: Case Heavenly Chocolates Website Transaction Heavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago the company developed a website and began selling its products. A sample of 50 Heavenly Chocolates transactions was selected from the previous month's sales The following shows the Excel output for the "Time (min)" variable (time spent the shoppers on the website), the "Page Viewed" (the number of website viewed),...
11] The Excel output on GPA below was generated from a sample of 30 students in Stats II using the descriptive statistics function in Excel. These are all sample statistics. What is the upper bound to the 95% confidence interval around the mean? n 30 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum 2.943666667 0.09068004 2.84 2.5 0.496675037 0.246686092 1.011303207 0.36205901 1.74 2.17 3.91 88.31 30 0.185461504 a. 2.978 b. 3.129 C. 3.341 d. 2.873...
I just need help on questions 7 and 8
The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks. (See exercise 35 on page 77 in your textbook for a similar problem.) Use the data in the FuelData sheet in this workbook to generate excel output to answer the following questions. Please note that units are "liters" for engine size and "miles per gallon" for highway fuel efficiency. Put the output in given space...
02. 1. Complete the Six Step Process (SSP) as defined Step Process (Version 1)," the Ch. 9 & 10 PPT slides and the Wk. 3 SG. You should note that I ha inseited background information and additional notes related to the case within the Excel worksheet in the reference titled"Hypothesis Testing the Six You will need to submit an Excel file containing your statistical output plus a Word document that contains all of your discussion points related to each step...
Summary of Descriptive Statistics Excel will tabulate a summary of the descriptive statistics for central tendency and using the Data Analysis Pack. Click Data Click Data Analysis .In the pop-up list click on Descriptive Statistics and hit OK . In the pop-up box in the input range type A2:A75 or highlight this region . Click the box next to summary statistics Click OK A box of summary statistics will appear like the one below Mean Standard Error Median Mode Standard...
Most questions answered within 3 hours.
-
A disabled tanker leaks kerosene (n = 1.20) into the
Persian Gulf, creating a large slick...
asked 5 minutes ago -
5. Explain the condition for a DC motor to develop the
maximum power. If a DC...
asked 20 minutes ago -
Compute the p[Ag] after 35.00 mL of 0.1 M silver nitrate has been
added to the...
asked 23 minutes ago -
Walgreen Company (NYSE: WAG) is currently trading at $48.50 on
the NYSE. Walgreen Company is also...
asked 37 minutes ago -
Based on historical data, your team knows what proportion of the
company's orders come from Males...
asked 55 minutes ago -
8. Which of the following atoms has the largest magnitude
electron affinity?
(a) Sodium (Na)
(b)...
asked 57 minutes ago -
Assess the two types of tests of cognitive abilities. (
regarding HR course)
asked 1 hour ago -
1.Write an inspiring vision statement for an organization where
you work or have worked. If the...
asked 1 hour ago -
2. Is fair trade coffee sustainable for the mass market,
or is it a niche product...
asked 1 hour ago -
Please answer this asap in MATLAB.
In the following for loop, the the loop is executed...
asked 1 hour ago -
A 50.0-g golf ball is driven from the tee with an initial speed
of 44.6 m/s...
asked 1 hour ago -
Use the molar concentration of the 50 mL solution to calculate
the moles of Cr(III) in...
asked 1 hour ago