Progress CheckUse this activity to assess whether you and your peers can:
Compare distributions to determine whether the primary goal of random assignment is achieved.
ContextA high school student named David Merrell did an experiment to examine if music affects the ability of rats to run a maze. The explanatory variable was exposure to music. He had three treatment groups: one group listened to heavy metal music by the group Anthrax. A second group listened to Mozart. The third group never heard music. This last group is the control group.
The response variable was the average time (in seconds) to complete three runs. Every week the rats ran the maze three times. Merrell recorded each rat’s average time for the week.
Direct controls of potential confounding variables:
Merrell trained all of the rats to run the same maze.
He gave all rats the same amount of food and light.
All rats had the same approximate age and weights.
During the treatment phase, the rats were exposed to the treatment for the same amount of time, e.g. rats heard music at 70 decibels for 10 hours a day for a month.
Results:
By the end of the month, the Anthrax group was much slower at running the maze. The Mozart group was much faster. The dotplots below show average run times for the first and last week of the experiment. Each dot represents one rat. The X-value is the rat’s average run time for the week. (Each rat ran the maze 3 times each week.) The blue line is the mean run time for each treatment group.
Module 6 Discussion BoardUse the Module 6 discussion board (opens in a new tab) to ask questions or provide feedback about the problems in any Module 6 activity – including this peer-reviewed assignment.
Review FeedbackPeer feedback should be available before final drafts are due.
Instructor feedback is only available after an assignment is graded.
Use these directions (opens in a new tab) to learn how to review feedback.
Click the “Next” or > button to continue.
Content by Cuyamaca College math faculty and licensed under the Creative Commons 4.0 International License (Links to an external site.).
RubricPeer Review (FD Optional) (1)
Peer Review (FD Optional) (1)
CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeFirst Attempt
5 ptsFull Marks
A first attempt was made on this assignment
0 ptsNo Marks
5 pts
This criterion is linked to a Learning OutcomeAnswering the Prompt
3 ptsFull Credit
All parts of the “Prompt” are addressed, and the responses demonstrate attainment of the learning objectives in the “Progress Check” section of the assignment. The answers are mostly correct. The writing/work is clear. The explanation/work is reasonable, well-organized, and easy to follow.
1.5 ptsPartial Credit
One or more parts of the “Prompt” are not addressed or are incorrect. Or, answers do not demonstrate attainment of the learning objectives in the “Progress Check” section of the assignment. Or, answers are correct, but the writing/work is unclear, incorrect, or difficult to follow.
0 ptsNo Marks
The “Prompt” is not addressed or the work is incorrect or missing. Or, the first draft was not a good-faith effort.
3 pts
This criterion is linked to a Learning OutcomePeer Review
2 ptsFull Credit
You completed the assigned peer review. The points you assigned in the rubric for the “Addressing the Prompt” criterion are appropriate. You used the “Add a Comment:” field to submit your assignment comments. Your assignment comments relate the score you assigned in the “Addressing the Prompt” criterion of the rubric to how your peer addressed the learning objectives when responding to the “Prompt.” (Note: the learning objectives are listed in the “Progress Check” section of the assignment.) If you awarded full credit for the “Addressing the Prompt” criterion in the rubric, your comments contextually and specifically explain what your peer did to demonstrate attainment of the relevant learning objectives. If you deducted points for the “Addressing the Prompt” criterion, you clearly explained what your peer can do better to demonstrate attainment of the relevant learning objectives.
1 ptsPartial Credit
You committed a good-faith effort to provide a high-quality peer review, but necessary instructive comments are missing. Or, you provided appropriate instructive comments but did not complete the rubric.
0 ptsNo Marks
No peer review provided or the comments are not instructive. Or, you did not commit a good-faith effort on your first draft.
2 pts
Total Points: 10
Tag: Statistics
as below R LANGUAGE ONLY
Review the attached file. Suzie has an issue. She can either move to NY or FL and needs to review some data that her agent gave her. The agent reviewed house prices and crime ratings for houses that Suzie would be interested in based on her selection criteria. She wants to live in an area with lower crime but wants to know a few things:
Is it more expensive or less expensive to live in FL or NY?
Is the crime rate higher in FL or NY (Note a low score in crime means lower crime)?
Is the crime rate higher in lower or higher house price areas?
Using the R tool, show the data in the tool to answer each of the questions. Also, show the data visualization to go along with the summary.
If you were Suzie, where would you move based on the questions above?
After you gave Suzie the answer above (to #4), she gave you some additional information that you need to consider:
She has $100,000 to put down for the house.
If she moves to NY she will have a job earning $120,000 per year.
If she moves to FL she will have a job earning $75,000 per year.
She wants to know the following:
On average what location will she be able to pay off her house first based on average housing prices and income she will receive?
Where should she move and why? Please show graphics and thoroughly explain your answer here based on the new information provided above.
Note: The screenshots should be copied and pasted and must be legible. Only upload the word document. Be sure to answer all of the questions above and number the answers. Be sure to also explain the rational for each answer and also ensure that there are visuals for each question above. Use at least two peer reviewed sources to support your work.
excel and cognos project
You will use Excel and the IBM Cognos tool to analyze and display data to solve problems and inform decision making. Using a method similar to the qualitative research process, you will identify an issue and use mathematical formulas or an analytic tool to derive a solution. You will create at least two visualizations using Cognos and its power of data analysis to inform your analysis and interpretation.
SCENARIO
Your supervisor has been assigned to be the interim manager of the IT Help Desk and needs your help. The previous help desk manager retired after many years in that position and never conducted any analysis of his team’s performance. Coming into this new job, your supervisor would like to gain more insight into the strengths and challenges of her help desk team.
First, you will need to collect data on the help desk tickets. This data will provide insight into the help desk’s performance and give you clues on how to improve the unit. You learn that the help desk has several goals. These goals relate to the measurement of key performance metrics, such as the number of days tickets are open and client satisfaction ratings. You would like to know how well the team members achieved these goals under the previous manager. Analysis of the help desk data will help you understand the team’s performance on these goals.
You plan to analyze the data using standard statistical methods in Microsoft Excel. However, one of your colleagues suggests that you also use a data analytics tool called Cognos Analytics, which could help you uncover hidden information. Cognos Analytics can also create graphic depictions of the key information to help you visualize the data. You decide to use both approaches.
Your task is to conduct data analysis and prepare a final report for your supervisor about your findings. Your report will include at least two visualizations created in Cognos and a set of recommended solutions for improving the performance of the help desk.
Your work will be evaluated using the competencies listed below.
1.1: Organize document or presentation clearly in a manner that promotes understanding and meets the requirements of the assignment.
1.2: Develop coherent paragraphs or points so that each is internally unified and so that each functions as part of the whole document or presentation.
1.4: Tailor communications to the audience.
1.5: Use sentence structure appropriate to the task, message and audience.
1.6: Follow conventions of Standard Written English.
3.1: Identify numerical or mathematical information that is relevant in a problem or situation.
3.2: Employ mathematical or statistical operations and data analysis techniques to arrive at a correct or optimal solution.
3.3: Analyze mathematical or statistical information, or the results of quantitative inquiry and manipulation of data.
3.4: Employ software applications and analytic tools to analyze, visualize, and present data to inform decision-making.
QM6640- Using Excel and Data Visualization Activity
We will start this activity in class when we begin Module 3. Use the provided data set to perform the operations listed below.
Determine each variable’s type – quantitative (discrete or continuous) or categorical. This will help determine which graphical display to use. See the extra sheet in the Excel file.
Create a histogram with one of the quantitative variables. You decide the appropriate number of bins. Copy and paste to a Word/pdf document.
Comment on the histogram’s center, variability, shape, and any unusal values.
Create a pie chart or bar chart with one of the categorical variables. Copy and paste to your Word/pdf document.
Comment on what you see in the pie/bar chart.
Create another visualization of your choice. Comment on the variable and visualization you selected and what relationships, patterns, or insights you found.
Turn in your 1-2 page Word/pdf document.
statistics Question 1
Complete the following problems, found at the end of each respective chapter in Tanner textbook. For these problems, feel free to use Microsoft Excel (or an equivalent), but submit all answers together in one file.
Chapter 2
Questions 6, 7, 8
Chapter 3Questions 2, 5, 7
4 questions in 7 hours from now due to 9/12/2022 10 PM ,PST time zone
Hello, I have to solve 4 questions that are attached to the file.
The first file has 4 questions
Please bid on who can solve all correctly (4 questions) and deliver the work due on September 12, 10 pm, based on PST time zone; thank you.
For the first file’s Instructions:
This assignment is open book and note with no strict time limit. You can use any course materials; you are also allowed to use results in the book, lecture notes, and past homework without repeating proofs or derivations. You may use statistical software, including (but not limited to) R or Python, to help answer these questions, or you may solve them manually. If you do use software, you must also submit your code.
I’ve also attached the previous assignment(solution with grading criteria) that will help you to understand the format and solve how to solve these questions.
Homework 1 Due Friday, September 09, 2022 Write your solutions on your paper, take pictures of your solutions and submit them
Homework 1 Due Friday, September 09, 2022
Write your solutions on your paper, take pictures of your solutions and submit them on canvas for grading.
Alternatively, submit you solutions, (on paper), in class on Friday, September 09.
1. A Math 273 class has 40 students. You are required to undertake a study to estimate the percentage
of the students in the class who have type B blood.
(a) What is the population for this study?
(b) What is the variable for this study?
(c) Describe how you would draw a simple random sample of 10 students for this study.
2. A new AIDS antibody drug is currently under study. It is given to patients once the AIDS symptoms
have revealed themselves. The table below gives the lengths of time, in months, a sample of 40 patients
lived from the start of treatment until their deaths.
2 4 11 15 16 17 22 44 37 16
14 24 25 15 26 17 33 29 35 44
13 21 22 10 12 8 52 32 16 20
11 34 29 27 8 24 18 51 33 34
(a) What is the population for this study?
(b) What is the variable for this study?
(c) Construct a grouped frequency distribution for the data, consisting of seven classes.
(d) Construct a histogram. How would you describe this histogram?
(e) Construct a frequency polygon.
(f) Construct an ogive.
3. The Önal letter grades earned on a mathematics course are given in the table below.
A B C D F W
10 11 20 12 3 4
(a) Use a pie chart to represent this data.
(b) Use a bar chart, with vertical bars, to represent this data.
4 questions 5 questions due to September 12, 6 pm based on PST time zone
Hello, I have to solve 9 questions that are attached to the file.
The first file has 4 questions and the second file has 5 questions.
Please bid on who can solve all correctly (4 questions 5 questions) and deliver the work due on September 12, 6 pm, based on PST time zone; thank you.
For the first file’s Instructions:
This assignment is open book and note with no strict time limit. You can use any course
materials; you are also allowed to use results in the book, lecture notes, and past homework without repeating
proofs or derivations. You may use statistical software, including (but not limited to) R or Python, to help answer these questions,
or you may solve them manually. If you do use software, you must also submit your code.
I’ve also attached the previous assignment(solution with grading criteria) that will help you to understand the format and solve how to solve these questions.
Discrete Probability Distributions Excel
Case study 3 covers Chapter 6: Discrete Probability Distributions. You will learn how to apply and calculate one of the important discrete probability distributions we learned in Chapter 6 in Excel. You should use the proper Excel function to calculate the desired probabilities.
You should solve and analyze the case studies by using Microsoft Excel. You should solely use the Excel features described in the Discrete Distributions (Excel Instruction) to complete the case studies. You should write any managerial insights in the same Excel file. It is recommended that you use separate sheets for each part of the case studies.
satistical method
Assignment2.1 Organizing Qualitative DataDue Sep 11 at 11:59pm Sep 11 at 11:59pm43.33/100 ptsScore: 43.33 out of 100 points.
Assignment2.2 Organizing Quantative Data: HistogramsDue Sep 11 at 11:59pm Sep 11 at 11:59pm-/100 ptsNo submission for this assignment. 100 points possible.
Assignment3.1 Measures of Central TendencyDue Sep 11 at 11:59pm Sep 11 at 11:59pm-/100 ptsNo submission for this assignment. 100 points possible.
Assignment3.2 Measures of DispersionDue Sep 11 at 11:59pm Sep 11 at 11:59pm-/100 ptsNo submission for this assignment. 100 points possible.
Assignment3.5 The Five Number Summary and BoxplotsDue Sep 11 at 11:59pm Sep 11 at 11:59pm-/100 ptsNo submission for this assignment. 100 points possible.
Assignment4.1 Scatter Diagrams and CorrelationDue Sep 11 at 11:59pm Sep 11 at 11:59pm-/100 ptsNo submission for this assignment. 100 points possible.
Assignment4.2 Least Squares RegressionDue Sep 11 at 11:59pm Sep 11 at 11:59pm-/100 ptsNo submission for this assignment. 100 points possible.
Assignment3.4 Measures of Position and OutliersDue Sep 11 at 11:59pm Sep 11 at 11:59pm-/100 pts