### Question Description

The file contains the weight in pounds from a sample of 368 pallets of Boston shingles and 330 pallets of Vermont shingles.

- For the Boston shingles, construct a 95% confidence interval for the mean weight.
- For the Vermont shingles, construct a 95% confidence interval estimate for the mean weight.
- Do you think the assumptions needed to construct the confidence interval estimates in 1 and 2 are valid?
- Based on the results of 1 and 2, what conclusions can you reach concerning the mean weight of the Boston and Vermont Shingles?

Refer to the Excel file **InsuranceClaims** for the assignment below:

The files contains data for 90 randomly selected auto injury claims.

- Construct a 95% confidence interval for the population proportion of all auto injury files that have exaggerated loss amounts.
- Construct a 95% confidence interval for the population mean dollar excess payment amount.

## Final Answer

Here is the answer. Thanks

Claim

Buildup

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

1

1

0

0

0

1

1

1

1

1

0

0

1

1

1

1

1

1

1

0

1

0

1

1

1

0

1

1

1

0

0

0

0

1

0

0

0

1

0

1

0

1

0

1

Excess

Payment

3260.34

188.56

0.00

0.00

0.00

73.27

4437.07

228.68

1895.11

115.70

0.00

0.00

376.25

80.00

183.86

116.64

150.00

230.00

1838.67

0.00

15.00

0.00

303.29

96.45

9.76

0.00

109.45

117.79

953.28

0.00

0.00

0.00

0.00

80.00

0.00

0.00

0.00

5677.57

0.00

210.00

0.00

157.50

0.00

1009.16

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

1

1

0

1

1

0

0

0

0

0

1

1

0

1

1

1

1

1

0

0

1

1

1

0

1

1

0

0

1

1

0

0

1

1

0

1

0

1

1

0

0

1

0

0

0

1

15.20

22.00

0.00

228.00

54.00

0.00

0.00

0.00

0.00

0.00

60.00

96.00

0.00

363.23

215.72

181.60

62.40

251.50

0.00

0.00

259.48

142.30

1004.58

0.00

50.00

130.34

0.00

0.00

363.20

12.80

0.00

0.00

11.20

379.20

0.00

434.46

0.00

29.70

1682.40

0.00

0.00

417.10

0.00

0.00

0.00

352.55

Claim

Buildup

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

1

1

0

0

0

1

1

1

1

1

0

0

1

1

1

1

1

1

1

0

1

0

1

1

1

0

1

1

1

0

0

0

0

1

0

0

0

1

0

1

0

1

0

1

Excess

Payment

3260.34

188.56

0.00

0.00

0.00

73.27

4437.07

228.68

1895.11

115.70

0.00

0.00

376.25

80.00

183.86

116.64

150.00

230.00

1838.67

0.00

15.00

0.00

303.29

96.45

9.76

0.00

109.45

117.79

953.28

0.00

0.00

0.00

0.00

80.00

0.00

0.00

0.00

5677.57

0.00

210.00

0.00

157.50

0.00

1009.16

Number of Loss

Proportion of Loss, p

Total Number of Observation, n

Z Value at 95% Confidence Interval

(1-p)

Margin of Error

Lower Bound of Confidence Interval

Upper Bound of Confidence Interval

The 95% confidence interval for the population proportion of all au

loss amounts is 0.5144 - 0.6189.

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

1

1

0

1

1

0

0

0

0

0

1

1

0

1

1

1

1

1

0

0

1

1

1

0

1

1

0

0

1

1

0

0

1

1

0

1

0

1

1

0

0

1

0

0

0

1

15.20

22.00

0.00

228.00

54.00

0.00

0.00

0.00

0.00

0.00

60.00

96.00

0.00

363.23

215.72

181.60

62.40

251.50

0.00

0.00

259.48

142.30

1004.58

0.00

50.00

130.34

0.00

0.00

363.20

12.80

0.00

0.00

11.20

379.20

0.00

434.46

0.00

29.70

1682.40

0.00

0.00

417.10

0.00

0.00

0.00

352.55

51

0.5667

90

1.96

0.4333

0.052234041

0.5144

0.6189

the population proportion of all auto injury files that have exaggerated

Claim

Buildup

1...

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors