It is thought that prehistoric Indians did not take their best tools, pottery, a

Question

It is thought that prehistoric Indians did not take their best tools, pottery, and household items when they visited higher elevations for their summer camps. It is hypothesized that archaeological sites tend to lose their cultural identity and specific cultural affiliation as the elevation of the site increases. Let x be the elevation (in thousands of feet) for an archaeological site in the southwestern United States. Let y be the percentage of unidentified artifacts (no specific cultural affiliation) at a given elevation. Suppose that the following data were obtained for a collection of archaeological sites in New Mexico:

x

5.50

6.50

7.50

7.75

8.75

y

15

32

55

39

72

x

5.50

6.50

7.50

7.75

8.75

y

15

32

55

39

72

Explanation / Answer

0.018726

Using excel data tool, regression equation will be

y = -75.923+16.462x

SUMMARY OUTPUT Regression Statistics Multiple R 0.937170513 R Square 0.878288571 Adjusted R Square 0.837718094 Standard Error 8.791750212 Observations 5 ANOVA df SS MS F Regression 1 1673.315 1673.315 21.64847 Residual 3 231.8846 77.29487 Total 4 1905.2 Coefficients Standard Error t Stat P-value Intercept -75.923 25.77519 -2.94559 0.060238 X Variable 1 16.462 3.537992 4.652791

0.018726

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.