Log in
Statistics
2
answers
0
watching
111
views

Being a virtual manager what are the various methods of communication that you will apply. Determine situational uses for communication methods and present your answer with the help of a table

Watch
2
answers
0
watching
111
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share
Priyanshu Patel
Priyanshu PatelLv10
28 Mar 2021
Already have an account? Log in
Share

Related textbook solutions

Introductory Statistics
OER Edition, 2013
Openstax
ISBN: 9781938168208

Related questions

During a clinical rotation on the medical-surgical floor of a hospital, you notice several patients have developed urinary tract infections (UTIs) associated with their Foley catheters (tubes inserted into the bladder to drain urine). Your staff physician agrees that this is a problem and offers to help with an improvement project. Together, you work through several PDSA cycles to reduce the rate of UTIs on your floor.

Which of the following methods would you recommend to display your improvement data?
  1. Draw a bar chart.
  2. Write a list of numbers.
  3. Create a two-column table.
  4. Draw a run chart.

Problem 1 (2 points). Every month a clothing store conducts an inventory and calculates the losses due to theft. The store would like to reduce these losses and is considering two methods to do so: the first is to hire a security guard and the second is to install cameras. The manager of the store has conducted the experiment: During the first 6 months he hired a security guard (method 1) and during the next 6 months he installed cameras (method 2). The monthly losses were reported as follows:

Security guard 350 289 407 398 470 259 Cameras 488 301 276 380 421 425

a/ Test with a=0.05 to determine whether there is enough evidence to conclude that expected monthly loss when installing cameras differs from 382. b/Since the cameras are cheaper than the guard, the manager would prefer to install the cameras unless there was enough evidence to infer that the guard was better. Conduct a hypothesis testing to advise what the manager should do? (Assuming equal variances and using a= 0.05)

Problem 2 (2 points). A supermarket chain performed a survey to help determine desirable locations for its new stores. The management of the chain wanted to know whether a linear relationship exists between weekly take home pay (s) and weekly food expenditures (y). A random sample of eight households produced the data shown in the following table Household 1 3 7 8 2 4 5 6 550 450 560 340 510 710 470 660

170 100 160 80 120 190 140 140 Y

a/ Find the least square regression line.

b/Perform the test Ho: Bi=0, H4: B10 (using a = 0.05) to determine whether there is enough evidence to infer that a linear relationship exists between weekly take home pay (s) and weekly food expenditures (y).

Multiple Choice

1. You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this task?

(a) Set a print area.

(b) Print titles.

(c) Adjust page breaks.

(d) Change the print page order.

2. You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and 2?

(a) Freeze Panes command

(b) Hide Rows command

(c) New Window command and cascade the windows

(d) Split Rows command

3. Which statement is not a recommended guideline for designing and creating an Excel table?

(a) Avoid naming two fields with the same name.

(b) Ensure that no blank columns separate data columns within the table.

(c)-Leave one blank row between records in the table.

(d) Include field names on the first row of the table.

4. Which of the following characters are wildcards in Excel? (Check all that apply.)

(a) *

(b) #

(e) ?

(d) $

5. What should you do to ensure that records in a table are unique?

(a) Do nothing; a logical reason probably exist to keep identical records.

(b) Use the remove duplicates command.

(c) Look at each row yourself and manually delete duplicate records.

(d) Find the duplicate records and change some of the data to be different

6. Which Conditional Formatting rule is best suited to apply formatting to the top five values in a range of values?

(a) Above Average

(b) Greater Than

(c). Top 10 Items

(d) Between

7. Which date filter option enables you to restrict the view to only dates that occur in March of 2018?

(a) Equals

(b) Before

(c) After

(d) Between

8. Which of the following is an unqualified structured reference?

(a) =[Purchase_Price]-[Down Payment]

(b) =Sales[Purchase_Price]-Sales[Down_Payment]

(c) =Purchase Price-Down_Payment

(d) =[Sales]Purchase_Price [Sales]Down_Payment

Ā 

9. Which of the following is not an aggregate function that can be applied in a total row?

(a) MAX

(b) AVERAGE

(c) COUNT

(d) VLOOKUP

Ā 

10. If you would like to set a conditional formatting rule based on the function=AND(G6"Finance". H7<7000), which formatting rule type is needed?

(a) Format all cells based on their values

(b) Format only cells that contain

(c) use formula to determine which cells to format

(d) Format only values that are above or below average

Weekly leaderboard

Home
Homework Help 3,900,000
Statistics 10,000
Start filling in the gaps now
Log in