MGMT 650 HW2 Fall 2023 -completed copy
.xlsx
keyboard_arrow_up
School
University of Maryland Global Campus (UMGC) *
*We aren’t endorsed by this school
Course
650
Subject
Management
Date
Feb 20, 2024
Type
xlsx
Pages
41
Uploaded by toluleye2015
MGMT 650 Fall 2023
Week 2 Homework Questions
Do all work in this file with no links to external files. For all questions, write your answers or calculations in the yellow cells.
Credit for your work requires calculations, pivot tables, and charts be linked to the data within this file.
02/15/2024
5.15
5.03
5.10
4.76
5.05
4.71
5.48
4.58
5.64
5.05
4.83
4.92
4.77
5.01
5.04
4.63
4.41
4.87
4.60
4.74
4.22
3.85
5.63
5.30
4.60
5.23
5.73
4.98
5.55
4.91
5.51
6.05
5.10
4.32
4.29
4.54
5.57
4.54
5.13
4.76
4.29
5.32
5.10
4.80
5.45
3.85
5.63
5.30
4.60
5.23
4.72
4.58
5.64
5.05
5.36
5.61
5.95
5.60
4.69
4.79
5.26
4.80
3.87
5.03
5.44
5.98
5.41
4.80
4.99
5.11
4.99
5.24
4.28
5.84
5.01
3.87
5.48
4.46
4.59
4.57
Compute the following statistics using individual Excel functions (not Data Analysis, Descriptive Statistics):
Mean
5.0
Median
5.0
hird quartile Q3 using QUARTILE.EXC
5.113
First quartile Q1 using QUARTILE.EXC
4.748
Interquartile range (IQR)
0.365
Maximum
5.150
Minimum
4.710
Range
0.440
For the standard deviation, when do you use STDEV.S and when do you use STDEV.P?
Variance
0.185
Standard deviation
4.967
Coeficient of Variation % (CV)
4%
data:
There are several ways to calculate quartiles that result in different answers. QUARTILE and QUARTILE.INC can produce a result that is not in the dataset or an unexpected result if you have a dataset with an even number of values.
STDEV. P: is used to calculate standard deviation based on the entire population given as arguments. STDEV. S: is used to calculate standard deviation based on a sample.
02/15/2024
The unit of physical measure associated with the standard deviation is the same as unit of data.
When calculating variance, the unit is squared. When data is in inches, variance is in inches squared.
Would you scale graphs and histograms in increments of variance or standard deviation?
I would sclae graphs in the inceement of standard deviation
Explain why the standard deviation is more useful than the variance.
As a contracted statistician, you have no prior experience with the company's product. Further,
the company has no prior process history, data, or statistics with which to compare.
Explain why there is or is not a concern with average bag weight comparing your calculation of
mean or median statistics and the nominal bag weight of 5 lbs.
Show what you have learned about the Coefficient of Variation (CV) from the text above
by answering what are two situations where the CV is especially useful?
When compared to variance, standard deviation is a better metric because it is in the same units as the data, making it more interpretable. However, because the variance is expressed in square units, it is difficult to interpret. Furthermore, The concern with average bag weight is whether it meets the expected value of 5 lbs. If the mean or median deviates significantly, it suggests an issue with the filling process.
The coefficient of variation (CV) is a measure of relative variability equal to the standard deviation divided by the mean, and formatted to %. It is regularly used to compare risk (volatility) in investing, and is especially useful in to compare data sets with different units of measure, or to assess data without prior data to compare. Consider weights of 10 oz, 13.4 oz, 15.1 oz with SD of 2.597 oz. The corresponding weights in pounds 0.625 lb, 0.838 lb, 0.944 lb have SD 0.162 lb. The SDs are not equal, yet the sample and its variability are the same. How can we compare variabilities? The CV, unlike other measures of variability, does not depend on the units of measure. The units of the standard deviation are divided out by the units of the mean. For a "rule of thumb", a CV of greater than 5% is considered significant.
When comparing the spread of data with different units.
9
10
What is the most common used-car manufacturer?
ford
What are the two least common?
mercury
See the tab "Used Car Data". This list represents a consolidated list from 2021 of used cars for sale on Craigs List in the Athens, GA area. The data set contains 421 used cars from the year 1995 or newer that sold for $1000 or more. The list also includes columns like price, condition, manufacturer and other relevant categories a buyer might find of interest.
Create a pivot table on a new worksheet
showing the frequency and percent frequency of the manufacturer from the Use
rover
11
12
What relationship do you see in this data between year and condition (How does age affect condition?).
the newer the year, the better the condition
Create a two way pivot table on a new worksheet
showing Year vs. Condition using the Used Car Data.
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 Questions
i need the answer quickly
arrow_forward
Pls help ASAP for both
arrow_forward
which alternative would you not want if you were a service technician?
arrow_forward
Fill in one possible resolution usually done by FO staff on a given scenario.
1.Room not ready
Resolution.
2.complain regarding out of order room.
Resolution.
3.fully book
Resolution.
arrow_forward
We are using google looker studio to find the data
arrow_forward
Part 1: The 5 project management groups have wide industry application in modern day project management. By using practical examples of your choice, demonstrate the practical application of the project management processes in bringing a project to a successful end (Detailed response required, also acknowledge information sources).
Part 2: A gantt chart is widely applied in project management as a project scheduling tool,whose format is in bar chart form. Critically examine a gantt chart as a project scheduling tool and practically demonstrate how it can also be used as a project planning and control technique (Detailed response required, also acknowledge information sources).
arrow_forward
please be genuine to answer the question
1033.
Discuss the challenges of integrating document flow with construction project information modeling.
arrow_forward
1 Cara's clients, Emily and Dave, have just had a baby and she would like to do something nice for them. She signs them up for a baby registry that sends them a small gift.
Emily and Dave will be sent information and service lists that are geared toward helping new parents. She provided their names, address and phone numbers so that they will
not miss any of the activities provided in the package. Has Cara dealt with her clients appropriately?
NUYLOTNQhObm1bEVKUTO90
a0 Cara did not protect her clients' privacy when she shared their personal information with the baby registry.
O Cara should not make this a regular practice. Her clients will begin to expect gifts and she will not be able to sustain this.
CO Cara should have set up an appointment to re-evaluate her clients' needs now that they have had a baby.
40 Cara's gift is very thoughtful and will help to build a relationship with her clients.
NUTYks10TNRUQ2h0bmkbEVKUTO90
arrow_forward
9:36
Assignment Details
Introduction to Business (BUSG-129-WJ1 CRN: 23348)
Description
After watching the following 4 UTube videos,
students are to discuss the keys points from
each of these 4 videos:
1. What is a stock market index?
2. Stocks, Bonds, Funds - What's the
difference?
3. What are dividends?
4. What is a 401K?
W
VES
Dashboard
56 ا...
Stock Market Index | by Wal...
3
CODIGO
T
View Discussion
000
000
Calendar
7
To Do
NA
Notifications
Inbox
arrow_forward
I ONLY NEED HELP WITH PART. (D) Please and thank you.
You may need to use the appropriate technology to answer this question.
Due to population growth in the area, the new Liberty High School has just opened in a local school district. The athletic director at Liberty High is planning the launch of the school's track and field team. The first team practice is scheduled for April 1. The activities, their immediate predecessors, and the activity time estimates (in weeks) are listed in the following table.
Time (Weeks)
Activity
Description
ImmediatePredecessor
Optimistic
Most Probable
Pessimistic
A
Meet with board
1
1
2
B
Hire coaches
A
4
6
8
C
Conduct fundraiser
A
2
4
6
D
Announce program
B, C
1
2
3
E
Meet with coaches
B
2
3
4
F
Order team equipment
A
1
2
3
G
Register athletes
D
1
2
3
H
Reserve buses for meets
G
1
2
3
I
Plan first practice
E, H, F
1
1
1
(a)
Draw a project network.
A project network with 11 activities and 13 directed arcs is…
arrow_forward
B. Match between column A and column B (14 Marks)
A
Breakeven point method
Indirect cost
PERT
Calculate schedule
Classification by Variability
Depreciation and administrative expenses
Project Planning/Scheduling
Total float
Provides contingency
Difficult to establish and maintain for a large project
Probability of completion before a specified date
slack time
СРМ
Gantt Chart
arrow_forward
how do i find the slack?
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
EX6-11 (Algo) A large Southeast city is requesting federal...
A large Southeast city is requesting federal funding for a park-and-ride project. One of the requirements in the request application is a
network plan for the design phase of the project. Sophie Kim, the chief engineer, wants you to develop a project network plan to meet
this requirement. She has gathered the activity time estimates and their dependencies shown here.
10 Description
A
B
Survey
Soils report
C Traffic design
0
Lot layout.
Approve design
E
F 111umination
G Drainage
H Landscape
I
Signage
3 Bid proposal
The project is expected to take
The critical path is
Early start for Activity E is:
Late finish for Activity F is:
Slack for Activity Cis:
Predecessor
None
A
A
A
B, C, D.
E
E
E
t
F. G, H, 1
Time
(days)
11
18.
15
7
85
25
18
23
15
8
days.
day(s)
arrow_forward
Preview File Edit
90% O E
Q O
Go Tools Window Help
a Stevenson, W. J. - Operations management. (14th ed.). McGraw-Hill-Mcgraw-Hill (2021).pdf (page 806 of 929)
O a bearch
Rev
How many weeks after the original start time should the project be finished?
7. Three recent college graduates have formed a partnership and have opened an advertising firm.
Their first project consists of activities listed in the following table.
operations
notes
6100
Stevenson,
a. Draw the precedence diagram.
W. J..21).pdf
b. What is the probability that the project can be completed in 24 days or less? In 21 days or less?
c. Suppose it is now the end of the seventh day and that activities A and B have been completed,
while activity D is 50 percent completed. Time estimates for the completion of activity D are 5,
6, and 7. Activities C and H are ready to begin. Determine the probability of finishing the proj-
ect by day 24 and the probability of finishing by day 21.
nd impre
o you w
CExtra
Screen Shot
20228 PM…
arrow_forward
Why is the construction of this 11-story building any more complex than the construction of an equivalent office building?
arrow_forward
Select the best answer for the question.
12. Customers like to choose the color of their cars. However, painting occurs early in the production process. Considering these two factors, which fulfillment process would you recommend?
O A. Mass customization through postponement
O B. Mass customization through modular design
OC. Project
OD. Batches
Mark for review (Will be highlighted on the review page).
>
O St
C
arrow_forward
Instructions
ASSIGNMENT
PROJECT SCENARIO: You are married and you are the
father or mother of a family of five with kids ages 10, 13 and
15) and a dog. The family has decided to take a camping trip
when the children are out of school for the summer. The
planned family camping trip is the project you will use to complete this assignment.
INSTRUCTIONS: Create a Responsibility Matrix for no less than seven activities to
be addressed in preparation for the family camping trip. Every member of the family
must be assigned primary responsibility to complete at least or more activities for the
project. Also, decide whether the dog will go on the camping trip with the family or
whether arrangements will be made for someone to care for the dog while the family
is away. Based on your decision regarding the dog, you must include at least one
activity associated with the dog as part of the project responsibility matrix.
Within the matrix, use "R" to indicate which individual has primary…
arrow_forward
Slack time B-G
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
Mailings
Review
View
me
E E • E =
AaBbCcDc Aa
AaBbCcDdEe
AaBbCcDdEe
Normal
No Spacing
Heading 1
Paint Window
Install
Sills
(2)
Windows
(2)
Remove Siding
Add New Siding
Paint Exterior
(2)
(4)
(2)
1
Install Interior
(2)
Remove Floor
(1)
4
Install New
Floor
(4)
Instructions: The network diagram above (activity on arrow) shows the activities needed to complete a
project to remodel a storage shed. The activities are listed as well as the time (in days) it will take to
complete them. Use this information to find the following values for each of these activities: early
start time, early finish time, late start time, late finish time (Probably best to do in an Excel file). Based
on this, find the slack time for each activity and identify the critical path.
2.
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
Hand written plz asap.... I'll rate plz fast
arrow_forward
Solve all
arrow_forward
From this selected reference: Bixby, A., B. Downs, and M. Self: “A Scheduling andCapable-to-Promise Application for Swift & Company,” Interfaces, 36(1): 69–86, January–February 2006.https://www.academia.edu/34766673/A_Scheduling_and_Capable-toPromise_Application_for_Swift_and_Company)
Summarize the background that led to undertaking this study.
arrow_forward
I need to do an essay about compare and contrast of The Yellow Wallpaper and The Story of an Hour?
arrow_forward
how can the below control problem be resolve in a business and how does this control problem affect the business
MISSING GUARANTED DEADLINE AND LATE DELIVERY
arrow_forward
create a network for planning and construction of the new hospital at Arnold Palmer
arrow_forward
Assignment Description and Instructions: The global outbreak of COVID-19 has had an impact on education and created new investment opportunities. A group of billionaires is considering investing in higher education in the Caribbean, which includes all post-secondary and tertiary institutions, and has turned to the budding entrepreneurs of MGMT2224 to provide them with the necessary industry information.
Your task is to conduct research and write a report on the Higher Education industry in St.Vincent and Grenadines so that the billionaires can decide whether to invest in a new higher education institution.
1. Executive Summary. This should be a one-page summary assessment of the higher education industry in the chosen country. Briefly state your recommendations that would help the industry advance.
2. Industry Analysis. Within the Industry Analysis, use all the following subheadings (followed by sufficient and well-cited analysis):
Political Factors (links must be made to the higher…
arrow_forward
Pls help with below homework
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON
Related Questions
- Fill in one possible resolution usually done by FO staff on a given scenario. 1.Room not ready Resolution. 2.complain regarding out of order room. Resolution. 3.fully book Resolution.arrow_forwardWe are using google looker studio to find the dataarrow_forwardPart 1: The 5 project management groups have wide industry application in modern day project management. By using practical examples of your choice, demonstrate the practical application of the project management processes in bringing a project to a successful end (Detailed response required, also acknowledge information sources). Part 2: A gantt chart is widely applied in project management as a project scheduling tool,whose format is in bar chart form. Critically examine a gantt chart as a project scheduling tool and practically demonstrate how it can also be used as a project planning and control technique (Detailed response required, also acknowledge information sources).arrow_forward
- please be genuine to answer the question 1033. Discuss the challenges of integrating document flow with construction project information modeling.arrow_forward1 Cara's clients, Emily and Dave, have just had a baby and she would like to do something nice for them. She signs them up for a baby registry that sends them a small gift. Emily and Dave will be sent information and service lists that are geared toward helping new parents. She provided their names, address and phone numbers so that they will not miss any of the activities provided in the package. Has Cara dealt with her clients appropriately? NUYLOTNQhObm1bEVKUTO90 a0 Cara did not protect her clients' privacy when she shared their personal information with the baby registry. O Cara should not make this a regular practice. Her clients will begin to expect gifts and she will not be able to sustain this. CO Cara should have set up an appointment to re-evaluate her clients' needs now that they have had a baby. 40 Cara's gift is very thoughtful and will help to build a relationship with her clients. NUTYks10TNRUQ2h0bmkbEVKUTO90arrow_forward9:36 Assignment Details Introduction to Business (BUSG-129-WJ1 CRN: 23348) Description After watching the following 4 UTube videos, students are to discuss the keys points from each of these 4 videos: 1. What is a stock market index? 2. Stocks, Bonds, Funds - What's the difference? 3. What are dividends? 4. What is a 401K? W VES Dashboard 56 ا... Stock Market Index | by Wal... 3 CODIGO T View Discussion 000 000 Calendar 7 To Do NA Notifications Inboxarrow_forward
- I ONLY NEED HELP WITH PART. (D) Please and thank you. You may need to use the appropriate technology to answer this question. Due to population growth in the area, the new Liberty High School has just opened in a local school district. The athletic director at Liberty High is planning the launch of the school's track and field team. The first team practice is scheduled for April 1. The activities, their immediate predecessors, and the activity time estimates (in weeks) are listed in the following table. Time (Weeks) Activity Description ImmediatePredecessor Optimistic Most Probable Pessimistic A Meet with board 1 1 2 B Hire coaches A 4 6 8 C Conduct fundraiser A 2 4 6 D Announce program B, C 1 2 3 E Meet with coaches B 2 3 4 F Order team equipment A 1 2 3 G Register athletes D 1 2 3 H Reserve buses for meets G 1 2 3 I Plan first practice E, H, F 1 1 1 (a) Draw a project network. A project network with 11 activities and 13 directed arcs is…arrow_forwardB. Match between column A and column B (14 Marks) A Breakeven point method Indirect cost PERT Calculate schedule Classification by Variability Depreciation and administrative expenses Project Planning/Scheduling Total float Provides contingency Difficult to establish and maintain for a large project Probability of completion before a specified date slack time СРМ Gantt Chartarrow_forwardhow do i find the slack? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill EducationManagement (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSONSpreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
- Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSONBusiness Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSONFundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON