Temple University

### Question Description

I’m trying to study for my Excel course and I need some help to understand this question.

I give some examples with solutions, finished the questions in activity6 like example

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Final Answer

Here you go :)

Investor

Return

1

5.49%

2

-1.86%

3

9.39%

4

5

6

1.30%

7.92%

10.36%

7

8

8.02%

8.27%

H0:

𝝁 = 0.10

9

11.29%

Ha:

𝝁 < 0.10

10

7.25%

11

8.54%

12

13

14

15

16

17

14.43%

7.30%

8.28%

7.09%

2.31%

11.26%

b. What is the observed value of the test statistic?

18

7.72%

c. What is the p-value of the appropriate hypothesis test?

19

20

9.70%

1.67%

21

22

23

11.84%

13.54%

11.54%

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

9.66%

6.12%

9.45%

4.38%

-1.19%

9.95%

1.41%

6.86%

2.27%

8.69%

11.99%

10.86%

8.93%

7.00%

4.75%

9.45%

3.98%

12.46%

14.53%

24.20%

Sam’s Investment Club is a national organization providing investm

Sam’s advertised that the average return for all its members is 10%

To show that Sam’s clients have an average return below 10%, the

The sample data is in Column B.

a. What are the null and alternative hypotheses for this test?

Sample mean:

Sample SD:

standard error:

z stat test statistic

p-value:

8.13%

0.047059

0.006655

-2.81223

0.00246

d. The SEC requires a 1% level of significance to initiate an invest

The SEC will investigate since the null hypothesis that the average return of Sam's Investme

investment Club has an average return of less than 10% at a 1% level of significance.

44

45

46

47

48

49

50

12.56%

14.98%

3.54%

8.99%

-0.40%

8.73%

9.65%

n providing investment advice to its members.

its members is 10%. A rival firm does not believe this claim.

urn below 10%, the rival firm commissioned a random sample of investors with Sam’s Investment C

s for this test?

hesis test?

to initiate an investigation. Based on your answers above, will the SEC investigate?

e return of Sam's Investment Club is 10% can be rejected. There is sufficient evidence to claim that Sam's

vel of significance.

Sam’s Investment Club.

House ID

1

2

3

Estimation Result

Over

Over

Under

Explanation of Categories

Over House prices estimate was Overestimated.

Under House prices estimate was Underestimated.

Correct House prices estimate was Correctly estimated.

4

Correct

5

Correct

6

Over

7

8

Over

Correct

9

10

Correct

Correct

H0:

p = 0.35

11

Correct

Ha:

p > 0.35

12

Over

13

Over

14

15

16

17

Correct

Over

Over

Correct

18

19

20

Correct

Under

Correct

21

Over

22

23

Over

Correct

24

Under

25

Over

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

Over

Correct

Correct

Correct

Under

Over

Correct

Over

Correct

Correct

Over

Correct

Correct

Correct

Over

Correct

Correct

Over

Zillow claims that it overestimates only 35% of market

You suspect that the percentage of inflated house pric

A survey of homes is reported. Use the spreadsheet

a. W...