Expert Answers

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...

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. KEY CONCEPTS: Recall from our 2.1 Discussion that a survey method is the means by which the data is obtained from the sample. For example, the survey method may be a telephone interview, a web-based questionnaire, or an in-person focus group. The sample mean or sample proportion is a statistic that was calculated from the sample used in your poll. It is part of the findings or results of your poll. For example, if you calculated the average age of a sample of randomly selected college students and you found that the mean of the sample was 25, the results of your poll would be that the average age of a college student (in the population of college students) is approximately 25. The margin of error is a measure by which your sample statistic may be overpredicting or underpredicting the actual value of the population parameter you are estimating. The margin of error is a calculation based on your confidence level, your sample size, and your standard deviation (how spread out the data values are). For example, if the mean age of your sample was 25, "plus or minus 2.9," you are saying that while you calculated that your randomly selected sample has an average age of 25, the actual mean population age is likely to be between 2.9 years less than 25 and 2.9 years more than 25. The range of numbers you obtain by performing these two calculations is your confidence interval (CI). For example, if the sample average age is x-bar = 25, and the margin of error is calculated to be E = 2.9, then the confidence interval (CI) would be CI = (x-bar - E, x-bar + E) = (25 - 2.9, 25 + 2.9) = (22.1, 27.9) You would approximate the average age in the population to be between 22.1 and 27.9. The confidence level is the level of certainty with which you make a claim about a population parameter. For the above example, if your margin of error was calculated using a confidence level of 95%, you would interpret your confidence interval by saying, "I am 95% confident that the average age of a college student is between 22.1 and 27.9 years." The confidence level is 95%. Another way to interpret this confidence interval is to say that 95% of samples randomly selected from this population will have an average age in this range of numbers (the confidence interval), but 5% of the samples randomly selected from this population may have an average age that does NOT fall in this range. When deciding whether a confidence level is "appropriate," we should consider the consequences of being "wrong." If we make a decision based on results for 95% of samples in a population, that decision may not be the best decision for 5% of samples in the population. Consider the following 2 statements: Your doctor is 95% confident about the number of guests who will enjoy the dessert he serves at his dinner party. Your doctor is 95% confident about the number of his patients who will die from an allergic reaction to a new medication he prescribes. Is the 95% confidence level an acceptable confidence level in both cases? (Most people would say they want the doctor to be more confident in his results about his patients! In other words, when we are deciding whether our 95% confidence level is "appropriate," we are considering the consequences of making a decision that could be wrong for the 5% of samples that will not have an average or proportion that fall within the calculated confidence interval and weighing the risks. Select the "Original Post" tab for instructions on how to make your first post in this discussion. ORIGINAL POST: Get on the Gallup websiteLinks to an external site.. Pick one of the articles (not a blog) on the Gallup website OR select an article from the "Resources" page of this discussion. In your original post, answer the following: Describe the survey methods used by Gallup. State a major finding, claim, or result in your poll involving a sample mean or sample proportion. State the margin of error presented in the article. (You may need to scroll down and find the “survey methods” box; then click the + to open this box and find this information.) State the confidence level for the poll. (You may find this in the article, or you might also find it in the "survey methods" box.) Construct a confidence interval for the sample mean or sample proportion you identified. Select the "Resources" tab for a list of some of the Gallup polls from which you can choose. You may also select a different poll from the Gallup website, provided you are able to address each of the discussion prompts with the poll you choose. Check with your instructor if you are unsure. Select the "Examples" tab to see what an original post for this discussion might look like. Select the "Replies" tab for instructions on what you should include in your replies to classmates in this discussion. RESOURCES: Saad, L. (2020, October 30). Americans plan to scale back on holiday spending this year. https://news.gallup.com/poll/322796/americans-plan-scale-back-holiday-spending-year.aspxLinks to an external site. Crabtree, S. (2020, October 29). Americans' social distancing habits have tapered since July. https://news.gallup.com/poll/322064/americans-social-distancing-habits-tapered-july.aspxLinks to an external site. Saad, L. (2020, October 29). Americans' readiness to get COVID-19 vaccine falls to 50%. https://news.gallup.com/poll/321839/readiness-covid-vaccine-falls-past-month.aspxLinks to an external site. Brenan, P. (2020, October 20). Americans favor saving over spending until vaccine. https://news.gallup.com/poll/318815/americans-favor-saving-spending-until-vaccine.aspxLinks to an external site. Brenan, M. (2020, October 29). More voters than in prior years say election outcome matters. https://news.gallup.com/poll/322010/voters-prior-years-say-election-outcome-matters.aspxLinks to an external site. Newport, F. (2020, October 28). Americans and the role of government. https://news.gallup.com/opinion/polling-matters/321767/americans-role-government.aspxLinks to an external site. Saad, L. (2020, October 29). U.S. satisfaction with women's treatment remains tepid. https://news.gallup.com/poll/317279/satisfaction-women-treatment-remains-tepid.aspxLinks to an external site. McCarthy, J. (2020, October 29). Ideal evenings for most Americans involve family time, TV. https://news.gallup.com/poll/313028/ideal-evenings-americans-involve-family-time.aspxLinks to an external site. Saad, L. (2020, October 29). U.S. conservatism down since start of 2020. https://news.gallup.com/poll/316094/conservatism-down-start-2020.aspxLinks to an external site. Gallup, I. (2020, May 21). The characteristics of good jobs for low-income workers. https://www.gallup.com/education/309911/characteristics-good-jobs-low-income-workers.aspxLinks to an external site. EXAMPLE POST: Example Original PostNote: the following discussion prompts are addressed for a "fabricated" Gallup poll. Describe the survey methods used by Gallup. In the poll I selected, data was collected by phone interviews. The sample was selected from the population of voters in a particular state using random-digit dialing. State a major finding, claim, or result in your poll involving a sample mean or sample proportion. Gallup researchers calculated in this study that approximately 39% of the randomly selected sample of voters in this state were undecided about who they would vote for in the next election. State the margin of error presented in the article. (You may need to scroll down and find the “survey methods” box; then click the + to open this box and find this information.) The researchers calculated the margin of error to be ±2.1%. State the confidence level for the poll. (You may find this in the article, or you might also find it in the "survey methods" box.) The researchers elected to use a confidence level of 95% for this study. Construct a confidence interval for the sample mean or sample proportion you identified. CI = (x-bar - E, x-bar + E) = (39% - 2.1%, 39% + 2.1%) = (36.9%, 41.1%)ReferencesDon't forget to include your APA-formatted reference for the Gallup poll that you discuss HERE!