Category: Statistics

Please include your name in the file’s name for submission.
The main objective o

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.

For this assignment, you will create a bar chart, a pareto chart, a dot plot, an

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.

Interpret the scatterplot
Answer the prompt questions in the attached rubric
Th

Interpret the scatterplot
Answer the prompt questions in the attached rubric
There is also a video attached to this rubric “The Happy Planet”
There is not a required length for this paper as long as all the required information is present.

Scenario
Smart businesses in all industries use data to provide an intuitive ana

Scenario
Smart businesses in all industries use data to provide an intuitive analysis of how they can get a competitive advantage. The real estate industry heavily uses linear regression to estimate home prices, as cost of housing is currently the largest expense for most families. Additionally, in order to help new homeowners and home sellers with important decisions, real estate professionals need to go beyond showing property inventory. They need to be well versed in the relationship between price, square footage, build year, location, and so many other factors that can help predict the business environment and provide the best advice to their clients.
Prompt
You have been recently hired as a junior analyst by D.M. Pan Real Estate Company. The sales team has tasked you with preparing a report that examines the relationship between the selling price of properties and their size in square feet. You have been provided with a Real Estate Data Spreadsheet spreadsheet that includes properties sold nationwide in recent years. The team has asked you to select a region, complete an initial analysis, and provide the report to the team.
Note: In the report you prepare for the sales team, the response variable (y) should be the listing price and the predictor variable (x) should be the square feet.
Specifically you must address the following rubric criteria, using the Module Two Assignment Template:
Generate a Representative Sample of the Data
Select a region and generate a simple random sample of 30 from the data.
Report the mean, median, and standard deviation of the listing price and the square foot variables.
Analyze Your Sample
Discuss how the regional sample created is or is not reflective of the national market.
Compare and contrast your sample with the population using the National Summary Statistics and Graphs Real Estate Data PDF document.
Explain how you have made sure that the sample is random.
Explain your methods to get a truly random sample.
Generate Scatterplot
Create a scatterplot of the x and y variables noted above. Include a trend line and the regression equation. Label the axes.
Observe patterns
Answer the following questions based on the scatterplot:
Define x and y. Which variable is useful for making predictions?
Is there an association between x and y? Describe the association you see in the scatter plot.
What do you see as the shape (linear or nonlinear)?
If you had a 1,800 square foot house, based on the regression equation in the graph, what price would you choose to list at?
Do you see any potential outliers in the scatterplot?
Why do you think the outliers appeared in the scatterplot you generated?
What do they represent?
You can use the following tutorial that is specifically about this assignment. Make sure to check the assignment prompt for specific numbers used for national statistics and/or square footage. The video may use different national statistics or solve for different square footage values.

*Closely read and follow the detailed instructions on the grading rubric at the

*Closely read and follow the detailed instructions on the grading rubric at the bottom of this page. The charts and tables you will need in the paper are fully described on the week 5 grading rubric.
This is a group project. I only have to complete number 1 ,2, 7 and 8. Add to the Group 6 Unit 5 Final assignment when completed.
Summary list of the grading rubric questions to be answered:
1. What are the demographic characteristics of the sample of RNs?
2. Is the variable “Years of Experience” normally distributed? Is there a linear relationship between the variables years of experience and household income?
3. draft submitted — see attached
4. draft submitted see attached
5. draft submitted see attached
6. draft submitted see attached
7. Can the number of years of RN experience (YrsRNExp) predict the number of medication errors (NumMedErrorsreported) a nurse will make?
8: Conclusions in Plain English -Summarize the results of the investigation in terms that a bedside nurse would understand. • Apply the results to nursing practice, research, and education.
*You are using the following Data for this project: MTH551_DatasetAllWeeks — attached
Use JASP to import data https://jasp-stats.org

Why are you applying for this specific programme, and how does it fit in with yo

Why are you applying for this specific programme, and how does it fit in with your future plans?
How does your experience and education make you a suitable candidate for this programme?
Answer this two question

The book name is Kelleher, J.D, Namee, B.M., & D’Arcy, A. (2020). Fundamentals o

The book name is Kelleher, J.D, Namee, B.M., & D’Arcy, A. (2020). Fundamentals of Machine for Predictive Data Analytics, 2nd Edition.
The book will be in that link https://mitpress.ublish.com/
Comments from Customer
Discipline: Data Science and Analytics Institute

Do all work in this file with no links to external files. For all questions, wri

Do all work in this file with no links to external files. For all questions, write your answers or
calculations in the yellow cells.
Credit for your work requires calculations, pivot tables, and charts be linked to the data
within this file. Calculations begin by typing =.
Full credit requires that answers involving calculation have supporting Excel calculations or Excel Data Analysis output, and charts and graphs must be linked to data in your downloaded file.

Which do you feel is generally a more useful inferential statistical procedure t

Which do you feel is generally a more useful inferential statistical procedure to aid in business decision-making: regression or t test? Explain your rationale and provide an example(s)

Download the Excel Template attached to this assignment onto your computer, open

Download the Excel Template attached to this assignment onto your computer, open it up, and read through the “Red Snapper Scenario” at the top of the page. All of this week’s assignments focuses on historical Red Snapper Catches for 2015 through 2018 (by Quarter) off the coast of Louisiana. The last four rows of the table are empty as 2019 is what you are going to forecast using the historical data for 2015 through 2018. As you scroll down through the Spreadsheet, you will notice in the far left column, there are five tasks for you to complete this week. Every one of these tasks is mirrored in the three YouTube videos below. Although this project is about Red Snapper Catches (your faithful designer’s favorite fish to catch and eat out of the southern bays of Louisiana) and the videos forecast Car sales, the process for forecasting the future year (in our case 2019) is identical.
You will want to watch these videos as you complete each of the five tasks. Where you want to transition from video 1 to video 2 and from video 2 to video 3 is very easy to see. One easy way to get started is to have a video open on one side of your screen and the excel template on the other.
it’s important that you complete the reading assignments first before you tackle this assignment.
There are several “Tasks” in the workbook; scroll down and make sure you have completed all five of the tasks in this assignment before pushing the send button. When you first open the Template, you may say “OMG, what have I gotten myself into?” Rightfully so, this is a big project, and, like eating an 18 inch pizza, it’s best done one bite at a time. So, look over the tasks and then access the first video and get going. It’s probably a good idea to watch the first video all the way through to get a feel for where you are going before starting on the first task. If you get lost and can’t quite figure out how to proceed, message your instructor, we are always glad to help.
This weeks assignment is best completed while watching the videos above; in order. It is recommended that you have the video open on one side (1/2) of your screen and the homework template on the second half of the screen. That way, you can watch the video and complete the assignment synchronously. Make sense?
You must use formulas to calculate every answer. No credit will be given if a number is simply inserted.
Here’s a (home made) help video that shows how to complete the Excel Spreadsheet: