Expert Answers

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!

Often, we search for data or research studies that are already available to help us make informed decisions, claims, or predictions about a population. When searching for such data or existing studies, it is important that we use credible and reliable information. The Gallup Poll is a polling organization that conducts public opinion polls on local, national, and global scales. Originating in the early 1900s, this long-standing organization is a generally well-respected, reliable, and accurate source of data and data analyses. In this discussion, you will explore Gallup polls in areas related to your field of study. We will identify and interpret key statistical concepts that we have studied last week and this week as they are applied in the Gallup polls. 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: When collecting data, the 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 survey method is a significant factor to consider when deciding whether the data obtained from the survey can accurately reflect a diverse population. When you are asked to describe the survey method, you are being asked to state how the data was collected from the sample. We recall from our 1.1 Discussion the population in a research study or statistical analysis is the overall group of people (or things) about which we are trying to make a claim, answer a question, or make a prediction. The sample is a subset of that population. We hope that we choose an effective sampling method so that the sample we obtain accurately reflects the diversity of the population. When you are asked to identify the sample group in the poll, some important facts to include are the size of the sample and how the sample was selected from the population it represents. Having a sample that is "large enough" and a sample that was selected with a carefully selected sampling method are important requirements for ensuring that the sample selected is most likely to be representative of the diversity in its population. To understand the diversity of a population, we should consider in what ways a population might be diverse. There are many commonly considered factors in diversity, including (but not limited to): age education level employment status/profession ethnicity geographic region gender and gender identification race religion sexual orientation socio-economic class There are many other factors which can contribute to the diversity of a population. When considering whether a sample represents the diversity of its population in this discussion, focus on the survey method and the sample identified. Is the survey method equally accessible and understandable to all members of the population so that every member of the population has an equal chance of accurately expressing their opinion in the survey? Does the sampling method provide that every member of the population has an equal chance of being selected for the sample? In your opinion, is the sample "large enough" to include a reasonably diverse subset of the population? Are there segments of the population that are likely to be underrepresented or left out of the sample based on the sampling method (how the sample was selected), or based on the survey method (how the data is to be collected)? These are the kinds of questions you should address when deciding whether the sample represents the diversity of its population. EXAMPLES Some ways the diversity of a population might not be represented in a study (related to survey method and sample): Members of lower income classes who don't have regular access to phone service might be underrepresented in a study in which uses telephone surveys and random digit dialing to deflect the sample and gather data. Members who speak English as a second language might be underrepresented in a study in which paper surveys (in English) were mailed to a simple random sample of the population A sample of only 100 people across the United States, no matter how they were selected, could not possibly accurately reflect the diversity of the entire country. 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 on the Gallup website OR choose one of the articles "Resources" page for your degree field. MY DEGREE FIELD IN CRIMINAL JUSTICE. In your original post, answer the following: Discuss one or two of the results or major findings (there will be a lot, so do not feel the need to discuss them all). Describe the survey methods used by Gallup. What sample group was used in the poll? Do you think the sample represents the diversity of the entire population? Be sure to document the poll you discuss in APA format so that your classmates may reference the poll as needed to reply to your post. 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. CRIMINAL JUSTICE RESOURCES: Naguib, C. (2020, October 29). Implications of inequitable policing in fragile communities. https://news.gallup.com/opinion/gallup/312707/implications-inequitable-policing-fragile-communities.aspxLinks to an external site. Crabtree, S. (2020, October 29). Large racial gaps on crime seen in 'Fragile Communities'. https://news.gallup.com/poll/251723/large-racial-gaps-crime-seen-fragile-communities.aspxLinks to an external site. McCarthy, J. (2019, May 24). Americans divided on priorities for criminal justice system. https://news.gallup.com/poll/196394/americans-divided-priorities-criminal-justice-system.aspxLinks to an external site. McCarthy, J. (2019, May 24). Americans' views shift on toughness of justice system. https://news.gallup.com/poll/196568/americans-views-shift-toughness-justice-system.aspxLinks to an external site. Brenan, M. (2021, November 20). Fewer Americans call for tougher criminal justice system. Gallup.com. https://news.gallup.com/poll/324164/fewer-americans-call-tougher-criminal-justice-system.aspxLinks to an external site. Jones, J. M., & Lloyd, C. (2021, November 20). Black Americans' reports of mistreatment steady or higher. Gallup.com. https://news.gallup.com/poll/352580/black-americans-reports-mistreatment-steady-higher.aspxLinks to an external site.