Look at the MS Excel file (titled “Easy_Tough”) available in the Blackboard. This file carries data about average MathSAT scores of 297 colleges and universities located in the USA and they are all classified into two groups of colleges and universities. One group of institutions are tough to graduate for students and another group of institutions are easy to graduate for students. Using MS Excel, perform analysis of variance test to examine whether the mean MathSAT score between these two groups are same or not. this is the data on excelEasy to graduate collegesTough to graduate colleges547495550526451480470533617429554529524568620550650535519506486540494509513459615526524377525543608490537513550466520544540502497480520531533470455400525494603395578445459460525372575504564480509520530542670522590440590510532419585330514457592436485433660426470433408440505455557486650399538508515488536436515393560439560 642 557 524 617 570 470 528 462 544 570 532 541 508 422 538 579 515 575 450 564 550 540 685 600 742 571 550 660 610 550 498 526 469 530 575 555 435 520 550 482 570 444 650 687 530 482 432 514 508 442 480 392 623 496 524 540 535 515 472 570 560 535 525 438 529 524 480 516 500 593 479 490 623 578 434 577 521 556 632 537 679 481 479 518 502 555 444 680 530 680 537 429 466 580 530 485 505 601 640 480 470 498 593 560 485 502 525 600 575 557 614 443 465 444 551 571 537 482 470 460 584 578 594 499 457 536 463 487 600 529 545 594 552 580 524 536 529 537 583 515 640 553 740 570 549 549 480 489 506 413 596 538 520 509 435 630 572 640 460 483 692 424 490 603 474 494 708 496 428 612 680 620 524 517 560 573 497 527 546 558 504 540 470 490 561 599 517 515 408 455

Answered: Look at the MS Excel file (titled…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Look at the MS Excel file (titled “Easy_Tough”) available in the Blackboard. This file carries data about average MathSAT scores of 297 colleges and universities located in the USA and they are all classified into two groups of colleges and universities. One group of institutions are tough to graduate for students and another group of institutions are easy to graduate for students. Using MS Excel, perform analysis of variance test to examine whether the mean MathSAT score between these two groups are same or not.

this is the data on excel

Easy to graduate colleges	Tough to graduate colleges
547	495
550	526
451	480
470	533
617	429
554	529
524	568
620	550
650	535
519	506
486	540
494	509
513	459
615	526
524	377
525	543
608	490
537	513
550	466
520	544
540	502
497	480
520	531
533	470
455	400
525	494
603	395
578	445
459	460
525	372
575	504
564	480
509	520
530	542
670	522
590	440
590	510
532	419
585	330
514	457
592	436
485	433
660	426
470	433
408	440
505	455
557	486
650	399
538	508
515	488
536	436
515	393
560	439
560
642
557
524
617
570
470
528
462
544
570
532
541
508
422
538
579
515
575
450
564
550
540
685
600
742
571
550
660
610
550
498
526
469
530
575
555
435
520
550
482
570
444
650
687
530
482
432
514
508
442
480
392
623
496
524
540
535
515
472
570
560
535
525
438
529
524
480
516
500
593
479
490
623
578
434
577
521
556
632
537
679
481
479
518
502
555
444
680
530
680
537
429
466
580
530
485
505
601
640
480
470
498
593
560
485
502
525
600
575
557
614
443
465
444
551
571
537
482
470
460
584
578
594
499
457
536
463
487
600
529
545
594
552
580
524
536
529
537
583
515
640
553
740
570
549
549
480
489
506
413
596
538
520
509
435
630
572
640
460
483
692
424
490
603
474
494
708
496
428
612
680
620
524
517
560
573
497
527
546
558
504
540
470
490
561
599
517
515
408
455

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

Expert Solution