https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analy

Prior to beginning work on this discussion forum, watch the 

Week 4 Introduction

 (Links to an external site.)
 video, and read Chapter 13 in the MindTap ebook by clicking on the Getting Ready link for each perspective chapter.

Step 1: Read:

· Review 
Case Problem 3: TourisTopia Travel


 
 Download Case Problem 3: TourisTopia Travelfrom Chapter 13 in the ebook.

Step 2: Do:

· Run the ANOVA: Two-Factor with Replication statistics for the Data File TourisTopia (Chapter 13) using the video 

How to Add Excel’s Data Analysis ToolPak

 (Links to an external site.)
 for assistance.

In a managerial report,

· Use descriptive statistics to summarize the data from Triple T’s study. Based on descriptive statistics, what are your preliminary conclusions about whether the time spent by visitors to the Triple T website differs by background color or font? What are yourpreliminary conclusions about whether time spent by visitors to the Triple T website differs by different combinations of background color and font?

· Explain whether Triple T has used an observational study or a controlled experiment.

· Use the data from Triple T’s study to test the hypothesis that the time spent by visitors to the Triple T website is equal for the three background colors. Include both factors and their interaction in the ANOVA model, and use a=.05.

· Use the data from Triple T’s study to test the hypothesis that the time spent by visitors to the Triple T website is equal for the three fonts. Include both factors and their interaction in the ANOVA model, and use a=.05.

· Use the data from Triple T’s study to test the hypothesis that time spent by visitors to the Triple T website is equal for the nine combinations of background color and font. Include both factors and their interaction in the ANOVA model, and use a=.05.

· Discuss whether the results of your analysis of the data provide evidence that the time spent by visitors to the Triple T website differs by background color, font, or combination of background color and font. What is your recommendation?

Step 3: Discuss:

· What recommendations does your ANOVA results support? Use findings from your managerial report to support your recommendations. Be sure to include why you support certain decisions over others. What surprising findings did you come up with during your analysis?

Guided Response: Review several of your peer’s posts. In a minimum of 100 words each, respond to at least two of your fellow students’ posts in a substantive manner, and provide information that they may have missed or may not have considered regarding the application of ANOVA tables in business and economics. Do you agree with their conclusions? Why or why not?