About 5 months ago, your company launched new branding for its video content. You believe the...

 

Transcribed Image Text:

About 5 months ago, your company launched new branding for its video content. You believe the new branding to be more engaging than the old branding. To measure this, you want to run a Hypothesis test that compares the 'Average Percent Viewed' of both the old and new brand. The brand-style is identified under the "Brand" column. The data needed is located in your download files for this course. The file is labeled 04-Exam-ABTest-Data.csv. Include all samples in your hypothesis test. Run this test in Excel. You'll use your results to answer the following questions. 13 Conduct a t-test. Use the data provided in the 04-Exam-ABTest-Data.csv. Your confidence level for this test will be at 95%. What is the p-value for our test? 0.001446 0.001567 0.003134 0.002892 About 5 months ago, your company launched new branding for its video content. You believe the new branding to be more engaging than the old branding. To measure this, you want to run a Hypothesis test that compares the 'Average Percent Viewed' of both the old and new brand. The brand-style is identified under the "Brand" column. The data needed is located in your download files for this course. The file is labeled 04-Exam-ABTest-Data.csv. Include all samples in your hypothesis test. Run this test in Excel. You'll use your results to answer the following questions. 13 Conduct a t-test. Use the data provided in the 04-Exam-ABTest-Data.csv. Your confidence level for this test will be at 95%. What is the p-value for our test? 0.001446 0.001567 0.003134 0.002892

Answer rating: 100% (QA)

SOLUTION Since the data cannot be shared a general algorithm to perform the ttest in excel is given ... View the full answer