EA 3 ANSWER FORM
pdf
keyboard_arrow_up
School
Purdue University *
*We aren’t endorsed by this school
Course
30301
Subject
Statistics
Date
Feb 20, 2024
Type
Pages
3
Uploaded by ProfEnergy8424
STAT 30301 –
EXCEL ACTIVITY 3: ANSWER FORM 20 points Enter your answers & Excel outputs by their problem numbers. Save completed form as a pdf. Submit completed pdf of THIS FORM to your Brightspace STAT 30301 Merge Course for credit.
GO TO NEXT PAGE FOR #8 - #12 1. Type your answers below. (2 points) The data for the 42
nd
observation tell us that the project is in the technology industry and will require a follow up. 2. Paste your Excel output below. (2 points) 3. Type your answer below. (1 point) Healthcare, Finance Retail, and Technology 4. Type your answer below. (1 point) Yes and No 5. Type your answer below. (2 points) P (Healthcare) = 51/111 = 0.4595, Marginal 6. Type your answer below. (2 points) P (Healthcare and Requires Follow-up) = 20/51 = 0.3911, Joint 7. Type your answer below. (2 points) P (No) = 62/111 = 0.5586, Marginal
8. Type your answer below. (2 points) P (Yes|Healthcare) = 20/51 = 0.3922, Conditional 9. Type your answer below. (2 points) P (Healthcare|Yes) = 20/49 = 0.4082, Conditional 10. Type your answer below. (2 points) P (Not Finance) = 1- P(Finance) = 1- (25/111) = 0.7748 11. Type your answer below. (2 points) P(Healthcare|Yes) P(Healthcare) No, Since P (Healthcare|Yes) = 0.4082 = Not equal to P(Healthcare) 12. SAVE THIS ANSWER FORM Document AS A PDF
; any other file type will receive AT MOST 75% credit for the assignment. Upload your SINGLE pdf file to the Excel Activity 3
Assignment in the Brightspace Merge course.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Please solve this question in handwriting. Again please need it in handwriting.
arrow_forward
Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary). Answers that need formulas must have them within the answer cell.
A manager is trying to educate employees on the effects of personal health and workplace performance. The manager has gathered data from a group of employees to evaluate the effects of sleep and sickness. The manager asked employees to record the total number of hours of sleep they had over 10 working days in two weeks and compared it to the number of sick days that each took over those 10 days.
Sick Days
Total hours of sleep
0
80
2
40
1
60
0
70
3
50
2
90
4
35
1
68
0
72
2
55
The manager wonders if a non-linear model is a better relationship between the variables.
Develop the model and run a regression adding the non-linear variable for total hours of sleep.
arrow_forward
Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary).
Answers that need formulas must have them within the answer cell. A manager is trying to educate employees on the effects of personal health and workplace performance. The manager has gathered data from a group of employees to evaluate the effects of sleep and sickness. The manager asked employees to record the total number of hours of sleep they had over 10 working days in two weeks and compared it to the number of sick days that each took over those 10 days. The manager wonders if a non-linear model is a better relationship between the variables.
Sick Days
Total hours of sleep
0
80
2
40
1
60
0
70
3
50
2
90
4
35
1
68
0
72
2
55
Is a linear or non-linear relationship better for hours of sleep predicting sick days and why?
Use the most appropriate model to forecast…
arrow_forward
Thank you for any feedback on this one.
arrow_forward
tion 2 of 15
Last summer, the Smith family drove through seven different states and visited various popular landmarks. The prices of gasoline
in dollars per gallon varied from state to state and are listed below.
$2.34, $2.75, $2.48, $3.58, $2.87, $2.53, $3.31
Click to download the data in your preferred format.
CrunchIt! CSV Excel JMP Mac Text Minitab PC Text R SPSS TI Calc
Calculate the range of the price of gas. Give your solution to the nearest cent.
range:
dollars per gallon
DELL
&
4.
7
8.
arrow_forward
This table shows the number of reported cases of a disease in a country.
Week
Size
400
500
625
3.
781
Write an equation that would model this data. Your answer should be in the proper form using correct letters and numbers with
no spaces.
arrow_forward
Find the five-number summary of the data. Be sure to include the screenshot of excel of your answers and formulas/command that you use.
arrow_forward
Johnson Filtration, Inc. provides maintenance service for water-filtration systems. Suppose that in addition to information on the
number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers
obtained a list showing which repairperson performed the service. The revised data follow.
Click on the datafile logo to reference the data.
DATA file
Repair Time
Months Since
in Hours
Last Service
Type of Repair
Repairperson
2.9
Electrical
Dave Newton
3.0
Mechanical
Dave Newton
4.8
8.
Electrical
Bob Jones
1.8
Mechanical
Dave Newton
2.9
Electrical
Dave Newton
4.9
Electrical
Bob Jones
4.2
6.
Mechanical
Bob Jones
4.8
8.
Mechanical
Bob Jones
4.4
4.
Electrical
Bob Jones
4.5
Electrical
Dave Newton
a. Ignore for now the months since the last maintenance service (1 ) and the repairperson who performed the service. Develop the
estimated simpe linear regression equation to predict the repair time (y) given the type of repair (2 ). Recall that…
arrow_forward
But how will I draw it month by month similar to the picture? Thanks.
arrow_forward
The r code for side by side boxplot of vitamind v newage and vitamin d v country.
Scatterplot code for relationship between vitamin d level and age.
arrow_forward
Please help with (d)
arrow_forward
alculate d for each patient by subtracting the number of hours of sleep with the drug from the number without the drug.
arrow_forward
Install RStudio: Begin by installing RStudio on your computer. If you haven't done so, please refer to the official RStudio website for download and installation instructions.
Watch the Tutorial Video: Watch the provided video tutorial that explains how to run RStudio. Pay close attention to the steps for opening and managing data files. https://www.youtube.com/watch?v=RhJp6vSZ7z0
Open RStudio: Once RStudio is installed, open the application.
Load the Dataset: In RStudio, open a data file named "mtcars". To do this, type the command mtcars in the script editor and run the command.
Attach the Data: Next, attach the dataset using the command attach(mtcars).
Examine the Variables: Carefully review and note the names of all variables in the dataset. Examples of these variables include:
Mileage (mpg)
Number of Cylinders (cyl)
Displacement (disp)
Horsepower (hp)
Research: Google to understand these variables.
Statistical Analysis: Select mpg variable, and perform the following…
arrow_forward
Alert for not submit AI generated answer. I need unique and correct answer. Don't try to copy from anywhere. Do not give answer in image formet and hand writing
arrow_forward
Sub part 6
arrow_forward
Please help me answer a,b and c with complete solution
arrow_forward
Now monitor the process. An additional ten days of data have been collected, see table labeled “1st 10 Days of Monitoring Reservation Processing Time” in the Data File.
Develop Xbar and R charts for the 1st 10 days of monitoring. Plot the data for the 1st 10 days on the Xbar and R charts.
Is the process in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart.
Based on the X-bar and R Charts that you developed for the 1st 10 days of data, is the process in control?
Group of answer choices
No. The X-bar and R Charts are both out of control.
No. The X-bar Chart is in control, but the R Chart is out of control.
No. The R Chart is in control, but the X-bar Chart is out of control.
Yes. The X-bar and R Charts are both in control.
arrow_forward
Just calculate to part c, d and e with detail.
arrow_forward
Problem 3
The following table gives the total number of people fully vaccinated in Oklahoma over a window of time in April of 2021:
Day (in April
People Fully Vaccinated
1
1243 871
2
1268778
3
1290 295
4
1307768
1315 073
6
1318146
7
1335 798
8
1351773
1368 221
10
1386123
14
1417964
15
1428 544
16
1438 343
17
1447 491
Part 1
Plot the data given in the table above. Be sure to label your axes appropriately.
Part 2
You will notice that data is missing for the dates April 11th-13th. Use the data from April 10th and 14th to extrapolate the total number of people vaccinated on each of the missing dates.
Part 3
Plot the missing data you computed along with the data from part 1. Be sure to use a different symbol and colour for the missing data.
arrow_forward
Please solve this question in handwriting. step by step. I am confused.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Related Questions
- Please solve this question in handwriting. Again please need it in handwriting.arrow_forwardPlease complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary). Answers that need formulas must have them within the answer cell. A manager is trying to educate employees on the effects of personal health and workplace performance. The manager has gathered data from a group of employees to evaluate the effects of sleep and sickness. The manager asked employees to record the total number of hours of sleep they had over 10 working days in two weeks and compared it to the number of sick days that each took over those 10 days. Sick Days Total hours of sleep 0 80 2 40 1 60 0 70 3 50 2 90 4 35 1 68 0 72 2 55 The manager wonders if a non-linear model is a better relationship between the variables. Develop the model and run a regression adding the non-linear variable for total hours of sleep.arrow_forwardPlease complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary). Answers that need formulas must have them within the answer cell. A manager is trying to educate employees on the effects of personal health and workplace performance. The manager has gathered data from a group of employees to evaluate the effects of sleep and sickness. The manager asked employees to record the total number of hours of sleep they had over 10 working days in two weeks and compared it to the number of sick days that each took over those 10 days. The manager wonders if a non-linear model is a better relationship between the variables. Sick Days Total hours of sleep 0 80 2 40 1 60 0 70 3 50 2 90 4 35 1 68 0 72 2 55 Is a linear or non-linear relationship better for hours of sleep predicting sick days and why? Use the most appropriate model to forecast…arrow_forward
- Thank you for any feedback on this one.arrow_forwardtion 2 of 15 Last summer, the Smith family drove through seven different states and visited various popular landmarks. The prices of gasoline in dollars per gallon varied from state to state and are listed below. $2.34, $2.75, $2.48, $3.58, $2.87, $2.53, $3.31 Click to download the data in your preferred format. CrunchIt! CSV Excel JMP Mac Text Minitab PC Text R SPSS TI Calc Calculate the range of the price of gas. Give your solution to the nearest cent. range: dollars per gallon DELL & 4. 7 8.arrow_forwardThis table shows the number of reported cases of a disease in a country. Week Size 400 500 625 3. 781 Write an equation that would model this data. Your answer should be in the proper form using correct letters and numbers with no spaces.arrow_forward
- Find the five-number summary of the data. Be sure to include the screenshot of excel of your answers and formulas/command that you use.arrow_forwardJohnson Filtration, Inc. provides maintenance service for water-filtration systems. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Click on the datafile logo to reference the data. DATA file Repair Time Months Since in Hours Last Service Type of Repair Repairperson 2.9 Electrical Dave Newton 3.0 Mechanical Dave Newton 4.8 8. Electrical Bob Jones 1.8 Mechanical Dave Newton 2.9 Electrical Dave Newton 4.9 Electrical Bob Jones 4.2 6. Mechanical Bob Jones 4.8 8. Mechanical Bob Jones 4.4 4. Electrical Bob Jones 4.5 Electrical Dave Newton a. Ignore for now the months since the last maintenance service (1 ) and the repairperson who performed the service. Develop the estimated simpe linear regression equation to predict the repair time (y) given the type of repair (2 ). Recall that…arrow_forwardBut how will I draw it month by month similar to the picture? Thanks.arrow_forward
- The r code for side by side boxplot of vitamind v newage and vitamin d v country. Scatterplot code for relationship between vitamin d level and age.arrow_forwardPlease help with (d)arrow_forwardalculate d for each patient by subtracting the number of hours of sleep with the drug from the number without the drug.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill

Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill