Time Period t Daily Sales 1 59 2 56 3 92 4 78 5 63 6...
|
Time Period t |
Daily Sales |
|
1 |
59 |
|
2 |
56 |
|
3 |
92 |
|
4 |
78 |
|
5 |
63 |
|
6 |
75 |
|
7 |
81 |
|
8 |
65 |
|
9 |
99 |
|
10 |
86 |
|
11 |
72 |
|
12 |
89 |
|
13 |
107 |
|
14 |
104 |
|
15 |
93 |
|
16 |
106 |
|
17 |
104 |
|
18 |
124 |
|
19 |
110 |
|
20 |
106 |
Given the Data Above for the first 20 days Daily Sales of a
new restaurant, use a Regression Tool like DATA ANALYSIS in Excel
and find each of the following:
Slope of Regression Equation =
Hint: Value should be between 2.1 and 3.2
Y Intercept for the Regression Equation =
Correlation Coefficient =
(Round to Nearest 100th, e.g., 0.9762123 =
0.98)
Coefficient of Determination =
(Round to Nearest 100th, e.g., 0.95299 = 0.95)
Using your Regression Equation, Predict Daily Sales for
Periods t=21, t=22, and t=23:
Daily Sales (21) =
Daily Sales (22) =
Daily Sales (23) =
Unless otherwise stated, Round all answers to the
nearest “tenth”, e.g., 16.41234 =
16.4 Enter whole numbers like 24
as 24.0
Homework Answers
Q.5: (12 marks) [CLO 1, 2, 3] Khalid has established a large trading company to import...
Q.5: (12 marks) [CLO 1, 2, 3] Khalid has established a large trading company to import mobile phones from Korea and sell in the MENA region. His sales data shows that there is a positive relationship between sales revenue and advertisement expenditure. He wants to forecast for revenues if the advertisement expenses are increased from current year's AED 12 million to AED 15 million. There are number of ways to forecast such as moving average method, and ftting a curve...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 13 21 14 20 23 15 (c) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation. MSE: The forecast for month 8: (e) Use trial and error to find a value of the exponential smoothing coefficient α...
1 Chapter 2: Applying Excel 3 Data 4 Sales 5 Variable costs: 6 Cost of goods...
1 Chapter 2: Applying Excel 3 Data 4 Sales 5 Variable costs: 6 Cost of goods sold 7 Variable selling 8 Variable administrative 9 Fixed costs 10 Fixed selling 11 Fixed administrative 12 13 Enter a formula into each of the cells marked with a ? below 14 Exhibit 2-9 15 16 Traditional Format Income Statement 17 Sales 18 Cost of goods sold 19 Gross margin 20 Selling and administrative expenses $12,000 $6,000 $600 $400 $2,500 $1,500 S 12,000 6,000...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your...
City code %drivers21 fatal accidents/1000 1 12 1.309 2 5 0 3 12 2.539 4 9 2...
city code
%drivers21
fatal accidents/1000
1
12
1.309
2
5
0
3
12
2.539
4
9
2.003
5
11
2.034
6
14
4.08
7
13
2.639
8
9
0.124
9
6
0
10
10
1.145
11
13
2.719
12
18
3.128
13
10
1.676
14
17
3.769
15
14
2.639
16
13
1.449
17
12
3.121
18
10
2.616
19
9
0.788
20
14
2.631
21
10
1.887
22
12
1
23
9
0.652
24
12
1.209
25
15
0.775...
1.) 2.) 3.) 4.) 5.) An advertising executive wants to estimate the mean weekly amount of...
1.)
2.)
3.)
4.)
5.)
An advertising executive wants to estimate the mean weekly amount of time consumers spend watching traditional television daily. Based on previous studies, the standard deviation is assumed to be 23 minutes. The executive wants to estimate, with 99% confidence, the mean weekly amount of time to within + 6 minutes. a. What sample size is needed? b. If 95% confidence is desired, how many consumers need to be selected? a. The sample size required for...
2. Using the data set of the Health Exam Results, conduct the following analysis between the variables of weight (WT) and Body Mass Index (BMI). Number the data set from 1 to 40, and select the...
2. Using the data set of the Health Exam Results, conduct the following analysis between the variables of weight (WT) and Body Mass Index (BMI). Number the data set from 1 to 40, and select the following individuals: . Set 1 (Malo): 1, 5, 10, 13, 15, 18, 19, 24, 29, 31, 32, 33 .Set 2 (Fomalo): 4, 9, 15, 16, 17, 22, 23, 29, 33, 37, 38, 40 Draw a scatter diagram of the sample of 12 data set...
This is the sequence 1,3,6,10,15 the pattern is addin 1 more than last time but what is the name for this pattern These are called the triangular numbers The sequence is 1 3=1+2 6=1+2+3 10=1+2+3+4 15=1+2+3+4+5 You can also observe this pattern
This is the sequence 1,3,6,10,15 the pattern is addin 1 more than last time but what is the name for this patternThese are called the triangular numbers The sequence is 1 3=1+2 6=1+2+3 10=1+2+3+4 15=1+2+3+4+5 You can also observe this pattern x _________ x xx __________ x xx xxx __________ x xx xxx xxxx to see why they're called triangular numbers. I think the Pythagoreans (around 700 B.C.E.) were the ones who gave them this name. I do know the...
PART 1 PART 2 PART 3 PART 4 PART 5 PART 6 PART 7 PART 8...
PART 1
PART 2
PART 3
PART 4
PART 5
PART 6
PART 7
PART 8
-11 points BBUnderStat12 22 005 Ask Your Teache My Notes It is costly in both time and money to go to college. Does it pay off? According to the Bureau of the Census, the answer is yes. The average annual income (in thousands of dollars) of a household headed by a person with the stated education level is as follows: 24.9 if ninth grade...
Al Greens is a franchise store that sells house plants and lawn and garden supplies. Although...
Al Greens is a franchise store that sells house plants and lawn and garden supplies. Although Al Greens is a franchise, each store is owned and managed by private individuals. Some friends have asked you to go into business with them to open a new All Greens store in the suburbs of San Diego. The national franchise headquarters sent you the following information at your request. These data are about 27 Al Greens stores in California. Each of the 27...
Q.5: (12 marks) [CLO 1, 2, 3] Khalid has established a large trading company to import mobile phones from Korea and sell in the MENA region. His sales data shows that there is a positive relationship between sales revenue and advertisement expenditure. He wants to forecast for revenues if the advertisement expenses are increased from current year's AED 12 million to AED 15 million. There are number of ways to forecast such as moving average method, and ftting a curve...
1 Chapter 2: Applying Excel 3 Data 4 Sales 5 Variable costs: 6 Cost of goods sold 7 Variable selling 8 Variable administrative 9 Fixed costs 10 Fixed selling 11 Fixed administrative 12 13 Enter a formula into each of the cells marked with a ? below 14 Exhibit 2-9 15 16 Traditional Format Income Statement 17 Sales 18 Cost of goods sold 19 Gross margin 20 Selling and administrative expenses $12,000 $6,000 $600 $400 $2,500 $1,500 S 12,000 6,000...
city code
%drivers21
fatal accidents/1000
1
12
1.309
2
5
0
3
12
2.539
4
9
2.003
5
11
2.034
6
14
4.08
7
13
2.639
8
9
0.124
9
6
0
10
10
1.145
11
13
2.719
12
18
3.128
13
10
1.676
14
17
3.769
15
14
2.639
16
13
1.449
17
12
3.121
18
10
2.616
19
9
0.788
20
14
2.631
21
10
1.887
22
12
1
23
9
0.652
24
12
1.209
25
15
0.775...
1.)
2.)
3.)
4.)
5.)
An advertising executive wants to estimate the mean weekly amount of time consumers spend watching traditional television daily. Based on previous studies, the standard deviation is assumed to be 23 minutes. The executive wants to estimate, with 99% confidence, the mean weekly amount of time to within + 6 minutes. a. What sample size is needed? b. If 95% confidence is desired, how many consumers need to be selected? a. The sample size required for...
2. Using the data set of the Health Exam Results, conduct the following analysis between the variables of weight (WT) and Body Mass Index (BMI). Number the data set from 1 to 40, and select the following individuals: . Set 1 (Malo): 1, 5, 10, 13, 15, 18, 19, 24, 29, 31, 32, 33 .Set 2 (Fomalo): 4, 9, 15, 16, 17, 22, 23, 29, 33, 37, 38, 40 Draw a scatter diagram of the sample of 12 data set...
PART 1
PART 2
PART 3
PART 4
PART 5
PART 6
PART 7
PART 8
-11 points BBUnderStat12 22 005 Ask Your Teache My Notes It is costly in both time and money to go to college. Does it pay off? According to the Bureau of the Census, the answer is yes. The average annual income (in thousands of dollars) of a household headed by a person with the stated education level is as follows: 24.9 if ninth grade...
Al Greens is a franchise store that sells house plants and lawn and garden supplies. Although Al Greens is a franchise, each store is owned and managed by private individuals. Some friends have asked you to go into business with them to open a new All Greens store in the suburbs of San Diego. The national franchise headquarters sent you the following information at your request. These data are about 27 Al Greens stores in California. Each of the 27...
Most questions answered within 3 hours.
-
If 5.70 g of potassium react with water, how many grams of
hydrogen gas, H2, are...
asked 5 minutes ago -
How many moles of CO2 and H2O will be
produced by combustion analysis of 0.010 mol...
asked 3 minutes ago -
Tennis champion Maria Sharapova is capable of serving a tennis
ball at 126 mph.
b) What...
asked 11 minutes ago -
The electric potential V in the space between the plates of a
given vacuum tube is...
asked 21 minutes ago -
The Hydroboration-Oxidation of an Alkene to Yield 1-Octanol.
1-octene to 1-octanol using BH3-THF
What might be...
asked 26 minutes ago -
You draw and keep a single bill from a hat that contains a
$11, $55, $20...
asked 43 minutes ago -
Write a Java program that has the following methods:
findSum - a method that takes in...
asked 44 minutes ago -
A coffee cup calorimeter initially contains 135g of water at
22.0oC. Calcium chloride (21.0g) at the...
asked 47 minutes ago -
A patient is having a magnetic resonance imaging scan (an MRI)
and has neglected to remove...
asked 49 minutes ago -
A student takes a multiple-choice test that has 10 questions.
Each question has two choices. The...
asked 1 hour ago -
Willie Keeler has a lifetime batting average of 0.341. Assume
that Willie Keeler came to bat...
asked 1 hour ago -
Which of the following has the highest boiling point?
A) 0.5m NaCl
B) 0.5m C6H12O6
C)...
asked 1 hour ago