Do all the sections in essay fprmat,Dataset is attached . put all the required 6 images 3 in each

Chapter 5 (20 points)

Consider a Kaspersky Lab survey of 2515 adult Internet users in the United States and Canada. Among those 2515 survey subjects, 46% said that they experienced at least one cybersecurity issue within the past five years. The cybersecurity issues include problems such as viruses, ransomware attacks, or malicious email. Here is a key question about this survey: Do the survey data support a claim that fewer than half (or fewer than 50%) of adult Internet users have experienced cybersecurity issues within the past five years? Clearly, 46% is less than 50%, but is 46% significantly less than 50%? Use the methods of this chapter to answer these questions:

• Among the 2515 survey subjects, what is the actual number of them who said that they experienced at least one cybersecurity issue within the past five years? Show how to find this amount. (4 points)
• Given the context of the Kaspersky Lab survey, is 46% significantly less than 50% in this case? Explain by using the Range Rule of Thumb for significantly low and/or significantly high values. (10 points)
• Based on the results from part b), what should be concluded about the claim that fewer than half (that is, fewer than 50%) of adult Internet users have experienced cybersecurity issues within the past five years? (6 points)

Chapter 6 (40 points; 10 points each)

Your company has a contract to perform preventive maintenance on thousands of air-conditioners in a large city. Based on service records from previous years, the time that a technician spends servicing a unit averages one hour with a standard deviation of one hour. In the coming week, your company will service a simple random sample of 70 units in the city. You plan to budget an average of 1.1 hours per technician to complete the work. Will this be enough time?

• Find the probability that it will take a technician at most 1.1 hours to service a randomly selected unit.
• Find the probability that the mean amount of time to service 70 units is at most 1.1 hours.
• What does your result from part b) suggest about your company budgeting 1.1 hours per technician to complete the work on one unit?
• Using the Range Rule of Thumb for significantly high values to determine the amount of time to budget for a technician to complete the work, determine the amount of time

Chapter 7 (40 points; 10 points each)

Surveys have become an integral part of our lives. Because it is so important that every citizen has the ability to interpret survey results, surveys are the focus of this project. Use the following.

A Gallup poll of 3297 U.S. adults showed that 54% of the respondents said it is unlikely that they would use a self-driving car.

• Use the survey results to construct a 95% confidence interval estimate of the percentage of all U.S. adults who say they are unlikely to use self-driving cars.
• Find the margin of error for this survey. How does it compare to this statement from Gallup: For results based on the total sample of 3297 U.S. adults, the margin of sampling error is percentage points at the 95% confidence level.?
• Explain why or why not an online news website would be justified in publishing this claim: Most U.S. adults say they are unlikely to use self-driving cars.
• A common criticism of surveys is that they poll only a very small percentage of the population and therefore cannot be accurate. Given that a sample of size 3297 from a population of 256,338,241 adults is a sample that is only 0.001% of the population, is that sample size too small? Write a brief explanation of why the sample size of 3297 is or is not too small.

Solve by hand and Python code.

solve the questions manually, and if Python code is required, please create it for all four questions.

i only need this 3, 8, 12, 13, 15

Assignment Three – T-tests Assignment Three

T-tests

Discuss what t-tests are. Explain the difference between one and
two-tailed t-tests. Explain the usefulness of your t-test findings
for statistical analysis. Download Applied Statistics from the link below as a reference.

Chose a data set and perform a t-test analysis on the data set.

Present the statistical analysis and include anything else you want from the data analysis output.

References

Phil Crewson, Applied Statistics, a Desktop Statistics Reference

Normal Distribution –

Hypothesis Tests – t-Tests

Difference between means and two sample t-test –

Difference between paired means – t-test –

T Distribution Calculator –

The Completed Assignment Could Be Like This. I. Discussion about t-tests a. What are t-test used for? b. Why t-test are inferential not descriptive statistics? c. What is the difference between the various types of t-tests? II. Statistical analysis a. identify a data set Figure One Data looks like this in the statistics program. b. complete statistical procedure on the data c. report the output from the statistical program Figure Two two sample difference of the mean t-test Figure Three paired sample t-test

what is the formula of combined mean

APPLICATION II COST ATTENDANCE

finish all questions

hello please help me with my assignment. I wasnt sure if if the answers are correct. I just want to make sure theyre good. Please give correction. And show the work through excel please.

the statistical table and everything are on it

I need full help completing Problem Set #5 for PPD 303: Statistics for Policy, Planning, and Development. Please look over the PDF instructions very carefully and follow all of my professors exact instructions. I am also attaching the Excel data file, and you should use the Excel data to solve the questions when needed, especially for the descriptive statistics and regression parts. Please make sure every part is completed correctly and clearly.

---

Submission / Formatting Requirements (Professors Instructions)

• Final submission must be a single file: .pdf, .doc, or .docx
• If any work is handwritten, it must be neat, legible, and organized
• For questions requiring Excel:
  • Provide the formulas used
  • Copy/paste results from Excel into the document
• Do not submit the Excel file itself
• For regression output, copy/paste the relevant regression results into the document
• If Excel table formatting gets messed up when pasting into Word, paste it as an image instead

---

General Instructions

• Solve every question and subpart completely
• Show all calculations, formulas, and work clearly
• Include Excel formulas/functions used whenever requested
• Use proper statistical notation
• Explain the steps clearly so I can understand how the answer was found
• Organize the answers by question number and letter
• Make the final work clean and easy to copy into a document for submission

---

Question 1 Population Proportions [9 points total]

Use the referendum survey data and answer all parts ah.

Please include:

• The point estimate for the proportion supporting the referendum
• The standard error used for a confidence interval
• A 99% confidence interval using Excel
• The Excel formula used for the critical z-value in the margin of error
• A 95% confidence interval using Table C
• A brief explanation of how Table C was used
• The null and alternative hypotheses for testing whether support is greater than three-fifths (60%)
• The standard error for the hypothesis test
• The test statistic and p-value
• The final conclusion

My professor also notes that using Table C is less accurate because of rounding, and that Excel or statistical software is preferred in real life, but Table C may be needed for exams.

---

Question 2 Difference in Population Proportions [9 points total]

Use the female vs. male support data and answer all parts ah.

Please include:

• The point estimates for female and male support proportions
• The standard error used for the confidence interval
• A 90% confidence interval using Excel
• The Excel formula used
• A 99.9% confidence interval using Table C
• A brief explanation of how Table C was used
• The null and alternative hypotheses for testing whether support differs between women and men
• The standard error for the hypothesis test
• The test statistic and p-value
• The final conclusion on whether there is a statistically significant difference

Again, my professor notes that Table C is less accurate because of rounding, so please be precise.

---

Question 3 Simple Regression [14 points total]

Use the attached PS5 Data.xlsx file.

The dataset contains data on 119 commuting zones in the U.S. with population at least 500,000. The relevant variables are in columns D through H:

• Life expectancy at birth
• Median household income
• Share without health insurance
• Share who currently smoke
• Share who regularly exercise

We are using these data to run simple regressions predicting life expectancy using the other four variables.

Part A

Use Data Analysis Descriptive Statistics in Excel to calculate the following for the five variables in columns DH:

• Mean
• Median
• Standard deviation
• Standard error

Part B

Use Data Analysis Regression in Excel to run four simple regressions with life expectancy as the dependent variable and each of these as separate explanatory variables:

1. Median household income
2. Uninsured rate
3. Share who smoke
4. Share who exercise

Please paste the regression results.

Important professor instruction:

• Do not include the ANOVA panel

Part C

Interpret the slope coefficient from each regression in plain English.

Important professor instruction:

• Each interpretation must refer to the actual variables in this assignment
• Do not use generic wording like Y, X, dependent variable, or explanatory variable

Part D

State the null and alternative hypotheses for the slope coefficient in a simple regression, and explain in plain Englishwhat those hypotheses mean.

Part E

Identify which explanatory variables, if any, have a statistically significant linear relationship with life expectancy.

Important professor instruction:

• Any claim of statistical significance must state the significance level clearly, such as:
  • 10%
  • 5%
  • 1%
  • 0.1%

---

Attached Files

I am attaching:

• The PDF with the full assignment instructions please read this very carefully before answering
• The Excel data file please use this data to solve the questions where needed