Assignment Task
Task
A-Plus Writing Help For University Students
Get expert assistance in any academic field. All courses and programs covered.
Get Help Now!Use the Data Analysis Tools (or other method) in Excel to select a random sample of 10 observations from the data in GEOG2420_W2022_A2_Data.xlsx (Worksheet 1), place these records into a new table and explain in detail how you obtained your sample. Using Excel, compute the variance and standard deviations for Wind and Temperature variables on both the original data and your sample. Present your results neatly in a table format and explain what variance and standard deviation values tell you about the data and how similar or different the values for the population and the sample are.
1. Restructure the data in GEOG2420_W2022_A2_Data.xlsx (Worksheet 2) into tabular format conducive to statistical calculations.
2. For the data you just restructured, compute the lower (Q2) and upper (Q3) quartile values for the maximum temperature variable. Combine these values with the minimum, maximum, and median to produce a 5-num Produce a single boxplot with two boxes, one for the high temperatures and one for the low temperatures. Label and present the graph appropriately.
3. Are there any outliers in the maximum temperature according to the 1.5?IQR test? If so, identify them. Provide all calculations in your Workbook and annotate to describe how you tested for outliers.
4. Human blood is grouped into four types. Show your work and calculations. The percentages of people in the USA with each type are provided below:
O 43?0?2?5%
Chose one person at random. Find the probability that this person
a) Has type B blood
b) Has type AB blood
c) Does not have type O blood
8. If two dice are rolled one time, find the probability of getting these results:
a) A sum less than 9
b) A sum greater than or equal to 10
c) A 3 on one die or on both dice
9. There are 12 students who wish to enrol in a particular course. There are only 4 seats left in the classroom. How many different ways can 4 students be selected to attend the class?
10. If 80% of the applicants are able to pass a driver’s proficiency road test, find the mean, variance, and standard deviation of the number of people who pass the test in a sample of 300 applicants.
11. Using the data in GEOG2420_W2022_A2_Data.xlsx (Worksheet 3), representing the number of calls received per day by a crisis hot line, find the mean, variance, and standard deviation of th distribution.
Welcome to our Online Essay Writing Agency. Securing higher grades costing your pocket? Order your assignment online at the lowest price now! Our online essay writers are able to provide high-quality assignment help within your deadline. With our homework writing company, you can order essays, term papers, research papers, capstone projects, movie review, presentation, annotated bibliography, reaction paper, research proposal, discussion, or another assignment without having to worry about its originality – we offer 100% original content written completely from scratch
We write papers within your selected deadline. Just share the instructions
