Ch1ClassTemplate

xlsx

School

San Jose State University *

*We aren’t endorsed by this school

Course

352

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

32

Uploaded by bbourassa090

Report
Color Key Insert your data Calculate/Identify The Answer Data Analysis Auto Calculated Auto Calculated Decision 4. Enter the cell range.
Output House Prices Mean 600000 Standard Error 357770.9 Median 300000 Mode 100000 Standard Deviation 800000 Sample Variance 6.4E+11 Kurtosis 4.130127 Skewness 2.006836 Range 1900000 Minimum 100000 Maximum 2000000 Sum 3000000 Count 5 Confidence Level(95.0%) 993331.2 5. Check the Summary Statistics box. 6. Click OK
Excel Online: Click on Insert => Cl Select Data. Select Data Analysis. Select Descriptive Statistics and click OK.
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
lick on Data => Click on Store => Type in XLMiner Analysis Toolpak
Statistics can be referred to as numerical facts. In a broader sense, statistics is 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
s the field of study dealing with the collection, analysis, presentation, and interp
pretation of data.
Enter the dataset in the following table Tablet Cost ($) Operating Display Battery System Size Life (inches) (hours) Acer Iconia W510 599 Windows 10.1 8.5 Amazon Kindle Fire HD 299 Android 8.9 9 Apple iPad 4 499 iOS 9.7 11 HP Envy X2 860 Windows 11.6 8 Lenovo ThinkPad Tablet 668 Windows 10.1 10.5 Motorola Droid XYboard 530 Android 10.1 9 Sony Tablet S 360 Android 9.4 8 How many elements? 7 How many variables? 5 Variable Categorical/Quantitative Cost Quantitive Operating system Categorical Display Size Quantitative Battery Life Quantitative CPU Manufacturer Categorical Variable Cost Ratio Operating system Nominal Display Size Ratio Battery Life Ratio CPU Manufacturer Nominal Measurement Scale Ordinal Ratio Nominal
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
CPU Intel TI OMAP Apple Intel Intel TI OMAP Nvidia Manufactu rer
Total number of respondents (n) 937 the numbe 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
er in the question
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? Total =SUM(B2:B5) What would make sense to use, averages or percentages as a summary of the responses? 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 co
# of responses 43 148 158 723 1072 Categorical Percentages 4 against allowing onducted annually and serves as an information source for the U.S. Department of
Transportation. In one part of the survey the person being interviewed was asked
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
d to respond to the following statement: "Drivers of motor vehicles should be allow
wed to talk on a hand-held cell phone while driving." Possible responses were stron
ngly agree, somewhat agree, somewhat disagree, and strongly disagree. respond
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
dents said that they strongly agree with this statement, said that they somewhat a
agree, 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
This trip to Hawaii is my: The primary reason for this trip is: Where I plan to stay: A. What is the population being studied? B. Is the use of a questionnaire good? C. Comment on each bullet point above
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
1st, 2nd, 3rd, 4th, etc. (10 categories, including vacation, convention, honeymoon) (11 categories, including hotel, apartment, relatives, camping) Total Days in Hawaii all visiotrs coming to the state of hawaii yes Question 1: Quantitive Question 2: Categorical Question 3: Categorical Question 4: Quantitve
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
Company Year 1 Year 2 Year 3 Year 4 Hertz 325 310 280 284 Dollar 173 131 118 121 Avis 198 227 309 265 a. Select a time series graph for the Year 1 to Year 4 showing the number of rental cars in service for e Create a line chart based on your input data Create a bar chart based on your input data c. Select a bar chart showing rental cars in service for Year 4. Year 1 Year 2 0 50 100 150 200 250 300 350 Chart Title Hertz Dollar Hertz Dollar Avis 0 50 100 150 200 250 300 Year 4
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
each company. Show the time series for all three companies on the same graph. Year 3 Year 4 Avis
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
Total number of adults surveyed (n) 1160 Number of respondents filing taxes electronically (x) 587 0.5060 754 categorical Estimate the percentage of all taxpayers who file electronically =x/n If (p)% of the people surveyed had their tax return prepared this way, how many people used an accountant or professional tax preparer? =p/100*n Would the data for the method for preparing the tax return be considered categorical or quantitative?
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
Sample Size (n) 2861 Respondents % 59% Annual Income 750,000 Amercian Express Credit Card % 50% What is the population of interest in this study? businessweek north american subscrib Is annual income a categorical or quantitative variable? quantitive categorical Does this study involve cross-sectional or time series data? cross-sectional the data support this interference the data does not support this interfer Is ownership of an American Express card a categorical or quantitative variable? An estimated 59% of the population of subscribers has an annual income of $75,000 or more. An estimated 60% of the population of subscribers has an American Express credit card.
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
bers rence
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
2 Sample Size (n) 3980 Number of women from the sample set developed tissue abnormalities (x) 63 Women out of the population (w) 1000 a. What were the populations? wommen whoes mo b. Do you suppose the data were obtained in a survey or in an experiment? Survey 15.8 7.91457286432161 1 Women whose mothers took the drug DES during pregnancy are? (m) Twice as likley (2) c. For the population of women whose mothers took the drug DES during pregnancy, estimate the number of women out of 1000 in this population who have tissue abnormalities =x/n*w d. For the population of women whose mothers did NOT take the drug DES during pregnancy, estimate the number of women out of 1000 in this population who have tissue abnormalities =B8/m e. True or false: Medical studies often use a relatively large sample (in this case, ) because disease occurrences can be rare and difficult to observe when only isolated populations are considered.
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 number others took DES during pregancy and women whose mothers did not out of 1000 women developed tissue abnormalities out of 1000 women developed tissue abnormalities
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 the 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 t
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
population the sample
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

t Test - Homework Assignment ANSKEY.xlsx
Key_Lab1.pdf
Key_Lab 9.pdf
Key_Lab 3.pdf
Ch 3 Class Template.xlsx
Excel Exam 1 2.xlsx
Gen 201 wk4 w.docx
Activity8-ErrorsAndPower-AnswerSheet (1).pdf
Activity6-Chi-SquareTests_AnswerSheet (1).pdf
ps33.pdf
ps55.pdf
ps44.pdf
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
SEE MORE TEXTBOOKS