8) As part of a study of corporate employees, the Director of Human Resources for QRS Company wants to compare the distance traveled to work by employees at their office in downtown Cincinnati with the distance for those in downtown Pittsburgh. a) State the Hypothesis to show mean number of miles traveled per month is different for Cincinnati and Pittsburgh employees. b) Choose a level of a. Use a = 0.05 for this problem. c) To test the hypothesis, the researcher collects data on 35 workers in the Cincinnati office and 40 in the Pittsburg office. The data appear in the QRS Company worksheet of the HW1 data workbook on Moodle. Collect data and calculate necessary statistics to test the hypothesis. d) Sketch the sampling distribution. Include the critical value and test statistic e) Draw a conclusion and report that in the problem context. f) Calculate the p-value for the hypothesis test g) Use Excel to perform the hypothesis test.
Cincinnati | Pittsburg |
406 | 347 |
333 | 379 |
346 | 360 |
331 | 360 |
400 | 379 |
368 | 339 |
350 | 385 |
384 | 353 |
351 | 397 |
369 | 369 |
368 | 418 |
362 | 367 |
334 | 391 |
313 | 387 |
322 | 421 |
335 | 370 |
412 | 353 |
317 | 353 |
378 | 376 |
415 | 382 |
376 | 410 |
434 | 371 |
388 | 402 |
408 | 402 |
377 | 354 |
371 | 391 |
382 | 412 |
367 | 305 |
365 | 385 |
363 | 412 |
410 | 346 |
367 | 411 |
374 | 401 |
407 | 393 |
367 | 360 |
366 | |
409 | |
389 | |
372 | |
423 |
a) NULL HYPOTHESIS H0:
ALTERNATIVE HYPOTHESIS Ha:
b) Level of Significance (alpha)= 0.05
c) To test the hypothesis we will assume following assumptions:
i) The samples are independent to each other.
ii) The samples are normally distributed.
iii) Populations Variances are unknown and equal to each other.
To verify last assumption we will use F test .
H0: POPULATION VARIANCES ARE EQUAL
Ha: POPULATION VARIANCES ARE NOT EQUAL.
From above test we can see that P value=0.1936 >0.05 therefore NOT SIGNIFICANT.
We can conclude that population variances are equal.
Now
From above table we can see that
t stat= -1.546
t stat= 1.546 (Two tailed test)
t critical= 1.99
P value =0.1263
Since P value >0.05 level of significance therefore NOT significant.
Decision: Fail to reject H0.
Conclusion: We don't have enough evidence to conclude that mean number of miles traveled per month is different for Cincinnati and Pittsburgh employees.
8) As part of a study of corporate employees, the Director of Human Resources for QRS...
As part of a study of corporate employees, the director of human resources for PNC Inc. wants to compare the distance traveled to work by employees at its office in downtown Cincinnati with the distance for those in downtown Pittsburgh. A sample of 35 Cincinnati employees showed they travel a mean of 370 miles per month. A sample of 40 Pittsburgh employees showed they travel a mean of 380 miles per month. The population standard deviations for the Cincinnati and...
A supermarket chain analyzed data on sales of a particular brand of snack cracker at 104 stores for a certain one week period. The analyst decided to build a regresion model to predict the sales of the snack cracker based on the total sales of all brands in the snack cracker category. c. The difference in category sales between two stores is 150. What is the predicted differnece of the cracker sales between these stores? CategorySales Sales 1348 394 1110...
Patronage Data: Fridays Saturdays Sundays 391 450 389 362 456 343 407 452 352 438 417 385 436 400 379 452 462 366 334 430 435 393 457 375 433 435 394 367 499 444 379 385 373 349 518 339 345 450 411 371 469 394 377 427 417 336 454 384 383 416 444 388 414 403 404 370 390 389 425 384 390 456 366 389 443 445 440 479 406 397 475 359 394 409 392...
Using the following information, I need help posting the closing entries to the T-accounts (using "clos." and the correspondjng number as shown in the journal entry as posting references) as well as preparing a post-closing trial balance. L16750 70 39,60 E 39,6 Less: (360) Acum, Depri. Truck (361) Total Plant assets 39, 400 E R _362) Total Assets Liabilities (363) Current liabilities (384) salaries pagable (365) Uncned revenue (386) total liabilities Stockholders' Equity (367) Commons to 25100 (368) Rtained earnings...
Hi it's python I imported a data which are so many words in txt and I arranged and reshaped with alphabetically both rows and columns I was successful with these steps but I am stuck with next step below is my code and screenshot import numpy as np import pandas as pd data=pd.read_csv("/Users/superman/Downloads/words_file2.txt",header=None) df_input=pd.DataFrame(data) df_output=pd.DataFrame(np.arange(676).reshape((26,26)), index = ['a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'], columns = ['a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z']) df_output.index.name="Start" df_output.columns.name="End" df_output This below screen shot is what I have to find I have to find each word...
Database Intro Salesmen Sheet Order_info Sheet Business_Info sheet 1.Create your own table design based on the Excel data, and include all relationships (joins). Apply referential integrity rules wherever appropriate. Import the data from Excel to Access to populate tables: 1. Use the Chen technique and illustrate the E-R diagram for the tables you created Note: It may be necessary to change the data composition due to normalization issues, if you change the composition detail how and why; (you may find...
HELP needed urgently....Data and question is attacted below..... Thank you in advance there is no data link fir this data it’s all in photos.... thank you i have already posted the question We were unable to transcribe this imageNo. 2 3 4 5 6 7 8 Working Sector Public Own Public Public Private Public Private Private Own Own Private Public Public Public Private 9 10 11 12 13 Public IS 16 17 18 19 20 21 22 23 24 25...