Excel Exam 1 2

xlsx

School

San Jose State University *

*We aren’t endorsed by this school

Course

352

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

38

Uploaded by bbourassa090

Report
Total number of respondents (n) 937 Sample size for this poll (n)? 937 Are the data categorical or quantitative? Categorical Percentages 525 Would it make more sense to use averages or percentages as a summary of the data for this question? Of the respondents in the United States, (p)% said Yes, they would want it to pass. How many individuals provided this response? Round your answer up to the nearest whole number. =p/100*n The Tennessean , an online newspaper located in Nashville, Tennessee, conduc
the number in the question cts a daily poll to obtain reader opinions on a variety of current issues. In a recent
t poll, 937 readers responded to the following question: "If a constitutional amend
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
dment to ban a state income tax is placed on the ballot in Tennessee, would you
u want it to pass?" Possible responses were Yes, No, or Not Sure ( The Tennessean
n website).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Strongly Agree Somewhat Agree Somewhat Disagree Strongly Disagree The responses are categorical or quantitative? What would make sense to use, averages or percentages as a summary of the responses? Total =SUM(B2:B5) What is the percentage of respondents strongly agree? =StronglyAgree/Total*100 Does the results indicate general support for or against allowing drivers of motor vehicles to talk on a hand-held cell phone while driving? The Bureau of Transportation Statistics Omnibus Household Survey is conducte
# of responses 43 148 158 723 1072 Categorical Percentages 4 against allowing ed annually and serves as an information source for the U.S. Department of Transp
portation. In one part of the survey the person being interviewed was asked to re
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
espond to the following statement: "Drivers of motor vehicles should be allowed t
to talk on a hand-held cell phone while driving." Possible responses were strongly
y agree, somewhat agree, somewhat disagree, and strongly disagree. responden
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
nts said that they strongly agree with this statement, said that they somewhat ag
gree, said they somewhat disagree, and said they strongly disagree with this sta
atement.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Statistical inference _____. a. refers to the process of drawing inferences about the sample based on the characteristics of th b. is the same as descriptive statistics c. is the same as a census d. is the process of drawing inferences about the population based on the information taken from
he population m the sample
Class Frequency Relative Frequency A 60.00 0.50 B 24.00 0.20 C 36.00 0.30 120.00 1.00 Total =SUM(B2:B4) =SUM(C2:C4) he response to a question has three alternatives:A, B, and C. A sample of 120
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0 responses provides 60 A ,24 B , and 36 C . Show the frequency and relative fre
equency distributions (use 2 decimal for the relative frequency column).
Class 10 to 19 10 10 0.2 20 to 29 13 23 0.46 30 to 39 16 39 0.78 40 to 49 7 46 0.92 50 to 59 4 50 1 Total 50 168 3.36 Note: Cumulative Frequency: Add Frequency to the left of row and any frequency above it Cumulative Relative Frequency: Take the Cumulative Frequency to the left and divide by the Total Cumul Consider the following frequency distribution. Class 10 13 16 7 4 Construct a cumulative frequency distribution and a cumulative relative frequ Frequency (enter records) Cumulative Frequency Cumulative Relative Frequency Frequency 10 - 19 20 - 29 30 - 39 40 - 49 50 - 59
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
lative Frequency uency distribution. Round your answers to two decimal places, if necessary.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Enter values below 53 55 71 Enter Descriptive Statistics here --> Row1 What is the Mean, Median, & Mode? Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
59 64 57 53 69 59.82 57 53 3 Mean =AVERAGE(Range) Median =MEDIAN(Range) Mode =MODE(Range) It appears =COUNTIF(Range,Mode) Compute the mean, median, and mode. Round your answers to decimal places if n
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
57 67 53 necessary ^^
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Mean (xbar) 3000 Standard Deviation (s) 1100 a. Z-score x1 2200 -0.73 b. Z-score x2 4900 1.73 2200 is (below/above) 0.73 Standard Deviation below 4900 is (below/above) 1.73 Standard Deviation above Any outlier? Neither are outliar because none are less that -3 or greatier th x3 13000 9.09 13000 is 9.09 Standard Deviation above z-score =STANDARDIZE(x1,mean,s) z-score =STANDARDIZE(x2,mean,s) c. Interpret the z-scores in parts (a) and (b). Comment on whether either should be considered a d. If the cost for a backyard shed-office combination built in Albany, California, is x, should this st z-score =STANDARDIZE(x3,mean,s) Many families in California are using backyard structures for home offices, art
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
the mean. the mean. han 3 the mean. The cost (is/is not) is an outlier. an outlier. Use absolute z-score values. tructure be considered an outlier? Explain. t studios, and hobby areas as well as for additional storage. Suppose that the m
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
mean price for a customized wooden, shingled backyard structure is $3000. Assum
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
me that the standard deviation is $1100.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
The range of probability is _____ a. any value larger than 0 b. any value between minus infinity to plus infinity c. 0 to 1, inclusive d. any value between –1 to 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
P(A) 0.5 P(B) 0.6 P(A n B) 0.4 0.6667 0.8 No because P(A|B) is not equal to P(A) a.   Find P(A|B) (to 4 decimals). =P(A n B)/P(B) b.   Find P(B|A) (to 4 decimals). =P(A n B)/P(A) c.   Are A and B independent? Why or why not? Suppose that we have two events, A and B, with P(A)= 0.50, P(B)= 0.60, and P(AnB) 𝑃(𝐴│𝐵)= (𝑃(𝐴∩𝐵))/(𝑃(𝐵)) Ind P ( A | P ( B
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
)=0.40. dependent: | B ) = P ( A ) or B | A ) = P ( B )
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Under 30 31 - 90 Initial Asking Price Under $150,000 50 30 $150,000 - $199,999 40 150 $200,000 - $250,000 20 280 Over $250,000 10 40 Total 120 500 0.24 0.122 0.0244 0.20 e. Are events A and B independent? No a. A is Over 90. What is the probability of A P(A)? =E6/F6 b. B is Under $150k. What is the probability of B P(B)? =F2/F6 c. What is the probability of A n B? =E2/F6 d. What is the P(A u B)? ooper Realty is a small real estate company located in Albany, New York, specia
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Over 90 Total Under 30 31 - 90 Over 90 Total 20 100 Under $150,000 0.0609756 0.0365854 0.0243902 0.1219512 70 260 $150,000 - $199,999 0.0487805 0.1829268 0.0853659 0.3170732 100 400 $200,000 - $250,000 0.0243902 0.3414634 0.1219512 0.4878049 10 60 Over $250,000 0.0121951 0.0487805 0.0121951 0.0731707 200 820 Total 0.1463415 0.6097561 0.2439024 1 alizing primarily in residential listings. They recently became interested in determ Independent: P ( A | B ) = P ( A ) or P ( B | A ) = P ( B )
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
mining the likelihood of one of their listings being sold within a certain number of
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
days. An analysis of company sales of 820 homes in previous years produced the
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
e following data.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

T8 D1.docx
t Test - Homework Assignment ANSKEY.xlsx
Key_Lab1.pdf
Key_Lab 9.pdf
Key_Lab 3.pdf
Ch 3 Class Template.xlsx
Ch1ClassTemplate.xlsx
Gen 201 wk4 w.docx
Activity8-ErrorsAndPower-AnswerSheet (1).pdf
Activity6-Chi-SquareTests_AnswerSheet (1).pdf
ps33.pdf
ps55.pdf
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
PREALGEBRA
Algebra
ISBN:9781938168994
Author:OpenStax
Publisher:OpenStax
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
PREALGEBRA
Algebra
ISBN:9781938168994
Author:OpenStax
Publisher:OpenStax
SEE MORE TEXTBOOKS