A survey of 40 students at a local college asks, "Where do you buy the majority of your books?" The responses fell into three categories: "at the campus bookstore," "on the Internet," and "other." The results are as follow. Use Excel to develop a 99% confidence interval estimate of the proportion of all of the college students who buy their books at the campus bookstore..Where Most Books Boughtbookstorebookstoreinternetotherinternetotherbookstoreotherbookstorebookstorebookstorebookstorebookstoreotherbookstorebookstorebookstoreinternetinternetotherotherotherotherotherotherotherinternetbookstoreotherotherinternetotherbookstorebookstoreotherbookstoreinternetinternetotherbookstore Enter your answers into the following table: AB (Type Formula)Value for B1Sample sizeSelect a record in the table and then ctrl+A402Response of Interest bookstore3Count for Response=COUNTIF(A1:A40,"bookstore") 4Sample Proportion 5 6Confidence Level 7Level of Significance 8z value 9 10Standard Error 11Margin of Error 12 13Point Estimate 14Lower Limit 15Upper Limit

Name: A survey of 40 students at a local college asks, "Where do you buy the
Uploaded: 2024-03-20T07:07:00.000Z
Channel: Bartleby
Description: A survey of 40 students at a local college asks, "Where do you buy the majority of your books?" The responses fell into three categories: "at the campus bookstore," "on the Internet," and "other." The results are as follow. Use Excel to develop a 99%

Answered: survey of 40 students at a local…

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section: Chapter Questions

Problem 8SGR

See similar textbooks

Related questions

Concept explainers

Topic Video

Question

A survey of 40 students at a local college asks, "Where do you buy the majority of your books?" The responses fell into three categories: "at the campus bookstore," "on the Internet," and "other." The results are as follow. Use Excel to develop a 99% confidence interval estimate of the proportion of all of the college students who buy their books at the campus bookstore..

Where Most Books Bought
bookstore	bookstore	internet	other	internet	other	bookstore
other	bookstore	bookstore	bookstore	bookstore	bookstore	other
bookstore	bookstore	bookstore	internet	internet	other	other
other	other	other	other	other	internet	bookstore
other	other	internet	other	bookstore	bookstore	other
bookstore	internet	internet	other	bookstore

Enter your answers into the following table:

	A	B (Type Formula)	Value for B
1	Sample size	Select a record in the table and then ctrl+A	40
2	Response of Interest		bookstore
3	Count for Response	=COUNTIF(A1:A40,"bookstore")
4	Sample Proportion
5
6	Confidence Level
7	Level of Significance
8	z value
9
10	Standard Error
11	Margin of Error
12
13	Point Estimate
14	Lower Limit
15	Upper Limit

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Hypothesis Tests and Confidence Intervals for Proportions$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.