Question

In: Finance

1) How many people were present for the signing of the Declaration of Independence?

1) How many people were present for the signing of the Declaration of Independence?

Solutions

Expert Solution

a)

b)

c)

Answers to a),b) and c)

year Demand 3 MA weighted average Exponential alpha = 0.03
1 4 5
2 6 4.7000
3 5 5.0900
4 5 5 5 5.0630
5 10 5.3333 5.25 5.0441
6 9 6.6667 7.5 6.5309
7 13 8 8.25 7.2716
8 15 10.6667 11.25 8.9901

Formula in Excel

year Demand 3 MA weighted average Exponential alpha = 0.03
1 4 5
=1+A2 6 =E2+0.3*(B2-E2)
=1+A3 5 =E3+0.3*(B3-E3)
=1+A4 5 =AVERAGE(B2:B4) =0.5*B4+0.25*B3+0.25*B2 =E4+0.3*(B4-E4)
=1+A5 10 =AVERAGE(B3:B5) =0.5*B5+0.25*B4+0.25*B3 =E5+0.3*(B5-E5)
=1+A6 9 =AVERAGE(B4:B6) =0.5*B6+0.25*B5+0.25*B4 =E6+0.3*(B6-E6)
=1+A7 13 =AVERAGE(B5:B7) =0.5*B7+0.25*B6+0.25*B5 =E7+0.3*(B7-E7)
=1+A8 15 =AVERAGE(B6:B8) =0.5*B8+0.25*B7+0.25*B6 =E8+0.3*(B8-E8)

d)

Using Excel

data -> data analysis -> regression

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9246
R Square 0.8548
Adjusted R Square 0.8306
Standard Error 1.6744
Observations 8
ANOVA
df SS MS F Significance F
Regression 1 99.0536 99.0536 35.3312 0.0010
Residual 6 16.8214 2.8036
Total 7 115.8750
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 1.4643 1.3047 1.1223 0.3046 -1.7281
year 1.5357 0.2584 5.9440 0.0010 0.9035
Observation Predicted Demand
1 3
2 4.5357
3 6.0714
4 7.6071
5 9.1429
6 10.6786
7 12.2143
8 13.75

Related Solutions

some people say that even today, the Declaration of Independence is a radical document. On a...
some people say that even today, the Declaration of Independence is a radical document. On a scale of 1 to 10 (least radical to most radical), how radical is it? address the question about the importance of human freedom in the Declaration of Independence and the U.S. Constitution. What do you think?
How did the Texas Declaration of Independence impact the Texas Constitution?
How did the Texas Declaration of Independence impact the Texas Constitution?
What is the contemporary relevance or significance of the declaration of independence?
What is the contemporary relevance or significance of the declaration of independence?
Where and how does the Declaration of Independence define the qualities a critical thinker has?
Where and how does the Declaration of Independence define the qualities a critical thinker has?
1.People were polled on how many books they read the previous year. How many subjects are...
1.People were polled on how many books they read the previous year. How many subjects are needed to estimate the number of books read the previous year within one book with 95​% ​confidence? Initial survey results indicate that sigmaequals19.4 books. A 95 % confidence level requires nothing subjects. 2.Find the critical values chi squared Subscript Upper L and chi squared Subscript Upper R for the given confidence level c and sample size n. cequals0.95​, nequals24 3.Use technology to construct the...
Describe the significance of the Declaration of Independence and the Articles of Confederation, as well as...
Describe the significance of the Declaration of Independence and the Articles of Confederation, as well as the weaknesses of the Articles. Write more than 200 words.
There are 12 signs of the zodiac. How many people must be present for there to...
There are 12 signs of the zodiac. How many people must be present for there to be at least a 50% chance that two or more of them were born under the same sign? 1-P(no one has the same sign) >= 0.5 P(two or more people have the same sign) = 1-P(no one has the same sign) = 1 - (12!/(12-n)!)/12^n 1-0.5=0.5 >= P(no one has the same sign) = 12!/(12^n * (12-n)!) 0.5 >= 12!/(12^n * (12-n)!) Solve for...
The following are ages of 16 of the signers of the Declaration of Independence. 30, 36,...
The following are ages of 16 of the signers of the Declaration of Independence. 30, 36, 33, 52, 37, 33, 38, 42, 31, 52, 46, 39, 41, 34, 50, 50 What is the 40th percentile? What is the 75th percentile?
explain the democratic concept or principle represented in the Declaration of Independence and/or the Constitution.
explain the democratic concept or principle represented in the Declaration of Independence and/or the Constitution.
In a recent survey, 2033 people were surveyed as to how many people preferred Tinder and...
In a recent survey, 2033 people were surveyed as to how many people preferred Tinder and how many people preferred Happn (a local dating website) and how many preferred Tinder in New York and Arizona. It was found that 1690/2033 people in New York liked using Tinder while 343/2033 preferred Happn and in Arizona, 1853/2033 people liked using Tinder while 180/2033 liked using Happn. Construct and interpret a 95% confidence interval for the difference between the two dating website preferences....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT