Category: Statistics

Compute the mean and median for the following three sets of scores. Also, identify the number that represents the mode. Usually, you would only find a mode for categorical variables and provide the name of the category, but I do want to see that you know how to find a mode, so provide me with the number that represents the mode

please follow all instructions
I am uploading assignment 1 so you can have some guide
use JASP software.
I uploaded sources to use.
THIS IS ASSIGNMENT 3

competency
In this project, you will demonstrate your mastery of the following competency:
Apply statistical techniques to address research problems
Perform hypothesis testing to address an authentic problem
Overview
In this project, you will apply inference methods for means to test your hypotheses about the housing sales market for a region of the United States. You will use appropriate sampling and statistical methods.
Scenario
You have been hired by your regional real estate company to determine if your region’s housing prices and housing square footage are significantly different from those of the national market. The regional sales director has three questions that they want to see addressed in the report:
Are housing prices in your regional market lower than the national market average?
Is the square footage for homes in your region different than the average square footage for homes in the national market?
For your region, what is the range of values for the 95% confidence interval of square footage for homes in your market?
You are given a real estate data set that has houses listed for every county in the United States. In addition, you have been given national statistics and graphs that show the national averages for housing prices and square footage. Your job is to analyze the data, complete the statistical analyses, and provide a report to the regional sales director. You will do so by completing the Project Two Template located in the What to Submit area below.
Directions
Introduction
Region: Start by picking one region from the following list of regions:
West South Central, West North Central, East South Central, East North Central, Mid Atlantic
Purpose: What is the purpose of your analysis?
Sample: Define your sample. Take a random sample of 500 house sales for your region.
Describe what is included in your sample (i.e., states, region, years or months).
Questions and type of test: For your selected sample, define two hypothesis questions (see the Scenario above) and the appropriate type of test for each. Address the following for each hypothesis:
Describe the population parameter for the variable you are analyzing.
Describe your hypothesis in your own words.
Identify the hypothesis test you will use (1-Tail or 2-Tail).
Level of confidence: Discuss how you will use estimation and confidence intervals to help you solve the problem.
1-Tail Test
Hypothesis: Define your hypothesis.
Define the population parameter.
Write null (Ho) and alternative (Ha) hypotheses. Note: For means, define a hypothesis that is less than the population parameter.
Specify your significance level.
Data analysis: Summarize your sample data using appropriate graphical displays and summary statistics and confirm assumptions have not been violated to complete this hypothesis test.
Provide at least one histogram of your sample data.
In a table, provide summary statistics including sample size, mean, median, and standard deviation. Note: For quartiles 1 and 3, use the quartile function in Excel:
=QUARTILE([data range], [quartile number])
Summarize your sample data, describing the center, spread, and shape in comparison to the national information (under Supporting Materials, see the National Summary Statistics and Graphs House Listing Price by Region PDF). Note: For shape, think about the distribution: skewed or symmetric.
Check the conditions.
Determine if the normal condition has been met.
Determine if there are any other conditions that you should check and whether they have been met. Note: Think about the central limit theorem and sampling methods.
Hypothesis test calculations: Complete hypothesis test calculations.
Calculate the hypothesis statistics.
Determine the appropriate test statistic (t). Note: This calculation is (mean – target)/standard error. In this case, the mean is your regional mean, and the target is the national mean.
Calculate the probability (p value). Note: This calculation is done with the T.DIST function in Excel:
=T.DIST([test statistic], [degree of freedom], True) The degree of freedom is calculated by subtracting 1 from your sample size.
Interpretation: Interpret your hypothesis test results using the p value method to reject or not reject the null hypothesis.
Relate the p value and significance level.
Make the correct decision (reject or fail to reject).
Provide a conclusion in the context of your hypothesis.
2-Tail Test
Hypotheses: Define your hypothesis.
Define the population parameter.
Write null and alternative hypotheses. Note: For means, define a hypothesis that is not equal to the population parameter.
State your significance level.
Data analysis: Summarize your sample data using appropriate graphical displays and summary statistics and confirm assumptions have not been violated to complete this hypothesis test.
Provide at least one histogram of your sample data.
In a table, provide summary statistics including sample size, mean, median, and standard deviation. Note: For quartiles 1 and 3, use the quartile function in Excel:
=QUARTILE([data range], [quartile number])
Summarize your sample data, describing the center, spread, and shape in comparison to the national information. Note: For shape, think about the distribution: skewed or symmetric.
Check the assumptions.
Determine if the normal condition has been met.
Determine if there are any other conditions that should be checked on and whether they have been met. Note: Think about the central limit theorem and sampling methods.
Hypothesis test calculations: Complete hypothesis test calculations.
Calculate the hypothesis statistics.
Determine the appropriate test statistic (t). Note: This calculation is (mean – target)/standard error. In this case, the mean is your regional mean, and the target is the national mean.]
Determine the probability (p value). Note: This calculation is done with the TDIST.2T function in Excel:
=T.DIST.2T([test statistic], [degree of freedom]) The degree of freedom is calculated by subtracting 1 from your sample size.
Interpretation: Interpret your hypothesis test results using the p value method to reject or not reject the null hypothesis.
Compare the p value and significance level.
Make the correct decision (reject or fail to reject).
Provide a conclusion in the context of your hypothesis.
Comparison of the test results: Revisit Question 3 from the Scenario section: For your region, what is the range of values for the 95% confidence interval of square footage for homes?
Calculate and report the 95% confidence interval. Show or describe your method of calculation.
Final Conclusions
Summarize your findings: In one paragraph, summarize your findings in clear and concise plain language.
Discuss: Discuss whether you were surprised by the findings. Why or why not?
You can use the following tutorial that is specifically about this assignment:
MAT-240 Module 7 Project Two Video
Down below I’ll enter part one of my projects and a couple of supporting materials needed to use to complete the assignment. Along with a template that is mandatory to follow.

instruction
You should add the Data Analysis add-on to your Excel.Excel for Mac: If you’re using Excel for Mac, in the file menu go to Tools > Excel Add-ins. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. This will load under the Data menu, and you will see “Data Analysis” on the right-hand side of the ribbon. Click Here for a short instructional video.
Excel for Windows: To add data analysis to Excel 2016, load the Analysis ToolPak add-in program go to File>Options>Add-Ins>check the Analysis ToolPak checkbox, and click OK. Click Here for a short instructional video.
View the Excel tutorial videos linked below.
You may also want to re-watch my video on box plots from the material in Chapter 4, relinked below.
Use the attached Excel spreadsheet to answer the descriptive statistics, create a box plot, and interpret your results.
You can answer the questions on the spreadsheet. Save and upload your completed assignment using the Chapters 3 and 4 Excel Assignment: Descriptive Statistics and Box Plots link below.
I must be able to click into the cell for any answer and determine the formula or command used to respond. it should not be pasted answers.
(1) using descriptive statistics to find measures of central tendency and dispersion
(2) how to compute quartiles and percentiles
(3) how to build a boxplot in Excel
(4) Box Plots from the material in Chapter 4
here is the link for the book pdf please used the formula of chapter 3 and 4 from book.
https://dokumen.pub/basic-statistics-in-business-a…

For this assignment, you will create a bar chart, a pareto chart, a dot plot, and a form for survey question responses using Google Form. Each task is worth 10 points. See the attached Excel document at the bottom of this assignment for the data sets. Task 1: Bar charts can be used to visualize categorical variables by showing a bar for each observed category. The height of the bar represents the frequency or relative frequency of that category. Use the provided data and the videos and instructions provided in the course to create a bar chart in Excel. Copy the chart into your Word document and then type “Source: American Veterinary Medical Association” under the graph.
Task 2: Pareto charts are bar charts with the bars sorted in descending order. The height of the bar represents the frequency or relative frequency of that category. Use the spreadsheet from Task 1 and the videos and instructions provided in the course to create a Pareto chart in Excel. Paste your Pareto chart in your Word document and then type “Source: American Veterinary Medical Association” under the graph.
Task 3: A dotplot can be used to visualize numerical data. They are used to get a sense of frequency. Use StatCrunch and the provided data to create the dotplot. Paste the dotplot in your Word document and then type “Exam Scores From an Introductory Statistics Course (Source: Not Specified)” under the graph.
Follow this StatCrunch video tutorial for guidance on creating the dotplot, if needed. https://www.youtube.com/watch?v=XYZ5VTv92yE
Task 4: Surveys are created to gather data. To efficiently collect data, the questions can be into a program and the survey link can be shared for participants to type in their answers. Create a survey with the following questions using Google Forms:
What is your current age?
What is your gender?
Female
Male
Prefer not to answer
What town do you live in?
Watch this video https://www.youtube.com/watch?v=Le7ercD6zjw for assistance in creating a survey with Google Forms. Share the link to your completed form in your Word document.
Task 5: Make a graph that best visualizes the provided dataset. Be sure to include details such as a title, data labels (if applicable), x-axis and y-axis label (if applicable), legend (if applicable), and source.

Please include your name in the file’s name for submission.
The main objective of this assignment is to help you learn and become familiar with using Excel for your future needs.
Please read questions carefully and follow guidelines to get full credits.
You may solve the problem with a financial calculator or manually (e.g., frequency and relative frequency). However, you should keep in mind that the main reason we use Excel is to easily process large data sets, and this assignment is a basic step toward that goal. In this regard, I strongly recommend that you make use of Excel functions as much as possible.

I have attached images of the instructions below. It comes with an article that is requried to complete the assignment as well as a template to use to answer the questions.
May2024 is article
img0261 and img0262 is the template
img0258 and img0259 is the instructions
It is reading the article and completing the questions in the template

1.) Canadian Adults with kidney disease were selected to participate in a survey regarding their views on cannabis use. 
Out of 160 responses, below are the top reasons provided for previous unprescribed cannabis use:
Collister, D., Herrington, G., Delgado, L., & Whitlock, R. (2023). Patient views regarding cannabis use in chronic kidney disease and kidney failure: a survey study. Nephrology Dialysis Transplantation, 38(4), 922–931. https://doi-org.ezproxy1.lib.asu.edu/10.1093/ndt/gfac226
What type of chart/graph would be best to display these data?
Group of answer choices
bar chart
histogram
line graph
boxplot
2.) Given the following data for resting heart rate among college students, what is the Interquartile Range? (Calculate by hand)
56 57 60 61 62 64 64 68 70 70 72 72 73 74 78 80 87 89 90
3.) Which of the following would be appropriate to use when displaying continuous interval/ratio data? (choose one or more)
Group of answer choices
pie chart
scatterplot
histogram
box and whisker plot
4.) What is the most basic method of illustrating data?
Group of answer choices
polygon
line graph
frequency distribution
pie chart
5.) A good rule of thumb when creating an illustration is ______.
Group of answer choices
to not label items
to use a lot of text
to make sure your graph communicates only one idea
to not worry about centering titles and axis labels
6.)  According to the attached boxplot, _______ specimens were bronchoalveolar lavage samples.
02-3box plot sputum samples.jpgDownload 02-3box plot sputum samples.jpg
Group of answer choices
8
24
106
6
7.) True or False, box plots are not affected by outliers.
Group of answer choices
True
False
8.) A scatterplot is the best visualization for showing which of the following (choose one or more)?
Group of answer choices
frequency of two nominal variables
correlation
The relationship between two interval/ratio variables
indirect or negative relationship between two ratio variables
9.) Which of the following visual representations uses bars to display the frequencies?
Group of answer choices
histogram
Tally-ho Method
ogive
frequency polygon
10.) If you have a set of scores with a range of 60 and you want 10 intervals, what should be the size of your class interval?
Group of answer choices
60
5
6
10
11.) Which of the following would be appropriate to display nominal data? (choose one or more)
Group of answer choices
bar graph
scatterplot
Histogram
Pie chart
12.) Which of the following is designed to present large amounts of information quickly, and uses pictures or shapes to display the information?
Group of answer choices
Powtoon
Pamphlet
Table
Infographic
13.) What term describes the groups that you divide your data into when creating a histogram? (choose one or more)
Group of answer choices
bin
frequency polygon
class interval
15.) If you were interested in tracking your GPA during the time you are in graduate school, which of the following might you use?
Group of answer choices
Histogram
Dot plot
Pie chart
Line chart
All of the above
16.) Which of the following tells you how often a certain score occurs?
Group of answer choices
Average
Quartile
Class interval
Frequency distribution
17.) If you wanted to visualize the change in the mean test score for the same exam over multiple semesters which visualizations might be used (choose one or more)?
Group of answer choices
pie chart
histogram
bar chart
line chart
20.) Which of the following is not one of the 5 number summary?  
Group of answer choices
Minimum
Q1
Median
Mean

Amount of work:
2 pagesDOUBLE
Subject:
Statistics
Type of paper:
Essay
Type of work:
Writing from scratch
Paper Format:
A
Academic Level:
Professional
Sources needed:
No specific sources required
Preferred language style:
US English

This week, we will examine the complex relationship between performance metrics and financial success in NASCAR, a highly competitive sport. The analysis highlights the significant impact of top 10 finishes on a driver’s earnings, which is much more important than other performance indicators like the number of poles won and the number of victories.
Your findings will lead to several interesting questions:
Strategic Implications
As top 10 finishes are more critical in determining drivers’ winnings than winning races, how might this influence team strategies and priorities during the season? Should teams focus more on consistency rather than targeting outright wins?
Performance vs. Payoff
The minimal impact of adding other performance variables (poles, wins, top 5 finishes) to the predictive model suggests a diminishing return on investments beyond achieving top 10 finishes. Does this imply a ceiling effect where additional efforts yield lesser financial rewards?
Modeling Insights
The adjusted R Square value improves slightly with the inclusion of multiple variables, but the only significant predictor remains the top 10 finishes. How do we interpret the role of multicollinearity in our model, and could further segmentation of top finishes (e.g., Top 2-5 and Top 6-10) provide better insights into the distribution of winnings?
Future Directions
Considering the significant role of top 10 finishes, how might NASCAR and teams leverage this insight for future strategies? Could this understanding shift the focus from merely winning races to achieving consistent performance across the season?
I encourage you to reflect on these questions. Your insights could shed light on strategic decision-making in sports management, particularly in how teams and drivers allocate resources and strategize to maximize financial returns.
Let’s discuss the broader implications of these findings for the sporting industry and how they might apply to other sports and competitive arenas.