Hits and Orders
Not what you're looking for?
USE EXCEL ONLY TO ANSWER34. Apperson and Fitz is a chain of clothing stores that caters to high school and college students. It publishes a quarterly catalog and operates a Web site that features provocatively attired males and females. The Web site is very expensive to maintain, and company executives are not sure whether the number of hits at the site relate to sales (i.e., people may be looking at the site's pictures only). The Web master has accumulated the following data for hits per month and orders placed at the Web site for the past 20 months:
Month Hits (1,000s) Orders (1,000s)
1 34.2 7.6
2 28.5 6.3
3 36.7 8.9
4 42.3 5.7
5 25.8 5.9
6 52.3 6.3
7 35.2 7.2
8 27.9 4.1
9 31.4 3.7
10 29.4 5.9
11 46.7 10.8
12 43.5 8.7
13 52.6 9.3
14 61.8 6.5
15 37.3 4.8
16 28.9 3.1
17 26.4 6.2
18 39.4 5.9
19 44.7 7.2
20 46.3 5.5
Develop a liner regression model for these data and indicate whether there appears to be a strong relationship between Web site hits and orders. What would be the forecast for orders with 50,000 hits per month?
Purchase this Solution
Solution Summary
The solution does a great job of answering the question. The solution is brief and concise and very easy to follow along. All the steps are clearly shown and Excel formulas are provided so that the student can answer similar questions in the future. It can be easily understood by anyone with a basic understanding of the topic. Overall, an excellent solution.
Purchase this Solution
Free BrainMass Quizzes
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.