Expert Answers

STA200 Homework 3 Based on Chapter 3. For this homework using MS Excel is optional. In the following exercises, we are going to calculate some statistics: the mean or average, the median, the mode, the variance and the standard deviation. 1) These are the scores from last week's geometry test: 90, 94, 53, 68, 79, 84, 87, 72, 70, 69, 65, 89, 85, 83, 72 Find the mean, variance, and the standard deviation. You earned a score of 72. How you did on the test compared to the rest of the class. 2) Find the median of the following data: 7, 9, 3, 4, 11, 1, 8, 6, 1, 4 3) Find the mode of the following data: 76, 81, 79, 80, 78, 83, 77, 79, 82, 75 4) You begin to observe to the color of clothing your employee’s wear. Your goal is to find out what color is worn most frequently so that you can offer company shirts to your employees. Monday: Red, Blue, Black, Pink, Green, and Blue Tuesday: Green, Blue, Pink, White, Blue, and Blue Wednesday: Orange, White, White, Blue, Blue, and Red Thursday: Brown, Black, Brown, Blue, White, and Blue Friday: Blue, Black, Blue, Red, Red, and Pink What is the mode of the colors above? 5) Mark operates Technology Titans, a Web site service that employs 8 people. Find the mean, variance, and the standard deviation of the age of his workers, if the ages of the employees are as follows: 55, 63, 34, 59, 29, 46, 51, 41

Step 1: Create a scatterplot Select the two columns and create a scatterplot. The column with the explanatory variable x should be on the left and the column with the response variable y on the right. Make sure your explanatory variable is on the horizontal axis. Add a main title and axis titles. Edit the range of the axes if the data appears “zoomed out” or odd on your plot. Add a trendline and R^2 to the plot. Step 2: Obtain the table of coefficients and residual plot Use your option's question of interest to state the null and alternative hypotheses Use data analysis toolpak to run a regression analysis Be sure to put the y variable first then the x variable. Include column names (labels) when selecting your data so you to see the explanatory variable name in the output! Select labels. Select the residual and residual plot options. Save your table and residual plot for your post. Ways to show your work: Take a screenshot of your excel workbook. Only the work part not the entire screen. Use the math formula button in Canvas. Take a screenshot of handwritten work on a tablet. Neatly hand-write your formulas on paper take a picture with your phone and upload the image within your post. Image needs to .jpeg. (please no words/sentences) STEP 3: EXPLAIN YOUR ANALYSIS AND SUBMIT YOUR ORIGINAL POST USE THE "ORIGINAL POST - OUTLINE & PROMPTS" TO CREATE YOUR ORIGINAL POST Use the title "Week 9 Data Analysis" Use the same headers as listed below (e.g., "State and Visualize" "Estimating the Relationship") in your post. Answer each question/prompt in the bulleted list below each heading in your post. For the math related questions, please show your work or excel functions you used to find your answers. Original Post - Outline & Prompts Week 9 Data Analysis State and Visualize Which option did you choose? What question are you trying to answer with your analysis? Paste your scatterplot with title, axis labels, trend line and R^2. In context, describe the relationship using strength, direction and form. LSRL and Assessing Fit Give the model in the form Paste the residual plot from Excel To assess if the assumptions for regression are reasonable, evaluate whether the residuals have any pattern violations. Explain your reasoning for whether the assumptions are or are not reasonable. Testing the Relationship Paste the table of coefficients from excel. Estimating Parameters Interpret the slope using the point estimate and 95% confidence interval from excel. Include context and practical insights or plausible implications from the results of the data. Conclude Write a conclusion describing the results. Use alpha = 0.05. Provide a statement in terms of the alternative hypothesis. State whether (or not) to reject the null. State the test statistic, degrees of freedom and p-value. Include context. information attached below

Please submit ONE excel file containing all your work and solutions. Please make sure your excel is well organized and easily readable and include separate sheets for: cover page, solutions to the different parts, raw data, and your work.

Opening and Saving an Excel Spreadsheet In this step, you will be opening and saving an Excel spreadsheet. Download the Technology Template. Note: There are four worksheets or tabs in this Excel spreadsheet. Take a few minutes to review the spreadsheet in its entirety. The four worksheet titles and the purpose of each worksheet are as follows. IT Help Desk Data—contains the data to be analyzed Data Legend—provides information about the data. Statistical Analysis—used in conjunction with Excel functions to determine the average number of days the tickets are open, the distribution of the requester's seniority, the type and severity of the problem, the assigned priority level, and the end user satisfaction level. The missing information may then be filled in as it is calculated. QR Analysis Essay—provides essay questions to answer after you perform your analysis using Excel and Cognos. Answers should be entered directly inside each box.

Lab 1: Identifying and Renaming Variables, Units of Measurement, and Data Codebooks This lab will introduce you to renaming variables and identifying and defining units of measurement using SPSS. You will also practice using a codebook.For this lab, we will use 2019 Monitoring the Future Survey data from 12th graders in U.S. schools. Please answer each of the following questions in full. For some, you will type your answers (please use full sentences with proper grammar). For others, you will copy screenshots or provide key information from your SPSS output. Please ALSO attach or submit your SPSS output with every assignment! You will lose 5 points if the SPSS output is not uploaded with the assignment submission. These assignments should be completed individually, and each person must submit an independent lab assignment. You are encouraged to discuss the labs with your peers/group, but each student should write up their answers independently. I have attached the word document that I would like filled out (please include the screenshot uploads). I also also attached the SPSS file, which I also need to submit with my work. I have also attached the codebook as you will be referring to that.

So essentially I have a Microsoft form from a survey collected from units of hospitals. I need you to sort through the data and make a presentation showing its findings. Using a powerpoint presentation I will attach. Essentially you are supposed to discuss findings and present the data with graphs in an attractive way. I will attach the slide template for you to you. Hospital Survey Presentation Assignment Objective: Create a professional presentation to effectively communicate hospital survey results to hospital directors. The presentation should provide clear insights, visual representations of data, and actionable recommendations for improvement. Assignment Instructions 1. Presentation Format: The presentation should be created in PowerPoint Use a professional and cohesive design that aligns with the provided sample slide. Ensure clarity, readability, and logical flow of information. 2. Content Requirements: A. General Results Slide Include an overview of survey results (graphs and key insights). Display data visually using graphs, charts, or infographics based on the provided Excel survey data. Summarize key trends and patterns in the data. Highlight notable written responses that provide qualitative insights. B. Unit-Specific Slides Create individual slides for each hospital unit (e.g., ER, ICU, Surgery, etc.). Present unit-specific graphs displaying survey data. Include qualitative responses relevant to each unit. Provide a brief analysis of the results, identifying trends, concerns, or positive feedback. C. Opportunities for Engagement & Improvement Identify areas where hospital leadership can engage with staff based on survey results. Suggest data-driven recommendations for improvement (e.g., training, communication strategies, policy changes). Ensure recommendations are practical and actionable. Share some common written responses from open questions 3. Design & Presentation Style: You must use the slide template I give you Keep text concise and impactful—use bullet points instead of large text blocks. Ensure graphs are clear and easy to interpret. Avoid clutter—each slide should focus on one key message. 4. Submission Requirements: Submit the final PowerPoint or Google Slides link in a shareable format. Ensure the file is editable in case of necessary modifications. The final submission should be polished, free of errors, and ready for presentation. Evaluation Criteria: Category Points Description Clarity & Organization 25 Logical structure, clear insights, easy-to-follow presentation flow. Visual Appeal 20 Professional design, effective use of graphs, charts, and minimal clutter. Data Interpretation 25 Accurate representation and analysis of survey results. Engagement & Improvement Strategies 20 Actionable recommendations based on data insights. Professionalism & Readability 10 Grammar, spelling, and formatting accuracy. Notes: Refer to the provided Excel survey data to create graphs and insights. https://docs.google.com/spreadsheets/u/0/d/1K0ap2ORRH-sz2Hc8Zo0UC5-USAxhOWpP/edit?dls=true&usp=gmail_attachment_preview spreadsheet Use a neutral and objective tone—present findings professionally. If you have questions, seek clarification early to ensure alignment with expectations.

Please complete this and show/submit all of the work. I have put the first half of the assignment along with the instructions for the second half below. Please make it very neat and show all of your work!

Part 1 examine a set of sample data, formulate a hypothesis, determine the appropriate t-test to run, and determine the alpha (a) level Part 2 Answer the questions under Part II, E through J on the Excel file you used in Part I

I have an assignment in the course called database systems , i need it without plagiarism and good work using simple words i am 2nd year of uni i will share instruction i need everything based of instructions , and if samples needed i need UAE region examples

A primary goal in this discussion is to recognize that applications in statistics (and, in particular, applications in descriptive statistics) can be found across disciplines, industries, and professions. We will be making connections with our classmates while sharing our own experiences and expectations regarding how statistics is meaningful in each of our everyday lives. Additionally, we will begin to explore some of the key concepts in this module by finding and examining real world, professional examples of descriptive statistics. Discussion Topic Begin this discussion by reviewing the "Key Concepts" to be considered when addressing the discussion prompts in the first tab below. Each of these concepts are elaborated upon in the text readings for this module. After reviewing the tabs for instructions for your "Original Post" and "Replies" for this discussion, select the "Examples" tab for examples of participation in this discussion. In your original post, describe the purpose of descriptive statistics. How can descriptive statistics be used in research situations based on your field of study? Provide a specific example of a descriptive statistic from your field of study in your discussion. This may be a chart, graph, or calculation (like mean, median, mode, or standard deviation). You may create your own statistics, find one on a website, or share an on-the-job example. Be sure to appropriately document the source of your descriptive statistic(s) using APA formatting. We know that descriptive statistics provide summary information on data collected from a sample or population. Does the source from which you found this statistic indicate who/what the sample is and how it was selected from the population? If not, use your knowledge or experience in this field to speculate on a reasonable sample or population from which you think the data might have been obtained and the sampling method that might have been used to obtain the data. Example Original Post How can descriptive statistics be used in research situations based on your field of study? I am working toward my BSN at ECPI so that I can become a nurse. In my studies we have seen that nurses use descriptive statistics on a daily basis. For example, to monitor a patient's blood pressure, the nurse might need to interpret a chart. Statistics can be used to support research in nursing in many ways. One way might be to gather and analyze data regarding the most common illnesses and medical needs in a community so that hospitals can plan and budget accordingly to best serve its patients and community. Provide a specific example of a descriptive statistic from your field of study in your discussion. Here is a specific example of a descriptive statistic that might be used in my field (Blood glucose level up to five hours after a meal). Does the source from which you found this statistic indicate who/what the sample is and how it was selected from the population? If not, use your knowledge or experience in this field to speculate on a reasonable sample or population from which you think the data might have been obtained and the sampling method that might have been used to obtain the data. The website did not state the specific sample or population used to obtain this data. I would guess it's actually two samples of patients, one group with diabetes and another group without ("normal") on which blood glucose levels were monitored for a five-hour period. One reasonable guess is that the samples were convenience samples based on patients available at the hospital collecting this data. ReferencesBlood glucose level up to 5 hours after a meal. (n.d.). https://www.liverpool.ac.uk/~trh/local_html/diabet...