33. It is thought that prehistoric Indians did not take their best tools, potter

Question

33. 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 x5.00 5.75 6.50 7.25 8.25 y 4040 67 71 98 Find b for the equation of the least-squares line y a+bx. A) 184.464 B) 58.064 C)-1163.511 D) -58.064 E) -184.464

Explanation / Answer

We can find slope( b ) using excel command.

FIrst X and Y in separate column

Click on any empty cell in excel and type, =SLOPE( select Y values , select X values ) and then hit enter.

Slope (b ) = 18.51

Here option is not here

Please ask to your professor about this question.

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

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