Question: Look at the enclosed MS Excel file (titled MathSAT), which carries two sheets. The data this file carries is average MathSAT scores of students admitted

Look at the enclosed MS Excel file (titled MathSAT), which carries two sheets. The data this file carries is average MathSAT scores of students admitted into colleges located in the USA.

Sheet 1 carries a randomly selected sample of 150 colleges average MathSAT scores of students. Using this data, construct a 95% confidence interval to estimate true MathSAT scores of students admitted into the colleges located in the USA.
Sheet 2 carries a randomly selected sample of 25 colleges average MathSAT scores of students. Using this data, construct a 99% confidence interval to estimate true MathSAT scores of students admitted into the colleges located in the USA.

[Note: Graph should be drawn and z values should be marked for both questions. After each graph, write down clearly your answer]

Sheet 1 :

Average MathSAT
547
550
451
470
617
554
524
620
650
519
486
494
513
615
524
525
608
537
550
520
540
497
520
533
455
525
603
578
459
525
575
564
509
530
670
590
590
532
585
514
592
485
660
470
408
505
557
650
538
515
536
515
560
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

Sheet 2:

Average MathSAT
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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Ramona and Hermione formed Wiley Corporation on January 2. Ramona contributed cash of $260,000 in return for 50 percent of the corporation's stock. Hermione contributed a building and land with the...

REGIONAL REALTY ASSOCIATION AUTHOR DATE PURPOSE ANALYSIS CORA WILKE 1/23/2016 ANALYSIS OF THE CLAIM BY LUKE LIBERTY REALTY No they should not advertise that they your get your price. On the analysis...

please help complete number one and show why its fraud in bulletin points and calculations in excel sheet please. ISSUES IN ACCOUNTING EDUCATION Vol. 19, No. 4 November 2004 pp. 505-527 Interstate...

TAX RATES AND ALLOWANCES The following tax rates and allowances for 2020/21 are to be used in answering the questions: Tax rates: Standard Rate 15% Progressive Rates First $50,000 Next $50,000 Next...

Questions 2 (25 marks) Mr. Look is a chief executive officer of W-design Company Ltd (W Co), a Hong Kong subsidiary of Wdesign House in the U.S.A. He is living with his parents and brothers. In...

INSTRUCTIONS 1. Answer ALL questions within 2,500 words limit (including figures and numbers) with +/- 10% 2. Print your word count on the last page of your assignment 3. 10 marks will be deducted if...

*i've post this question part A,B and C seperately but both 3 of the chegg experts didn't Answers my question, they literally ignore my questions(All three of them) and i waited for so long alr... i...

Overview You have just started an internship at Workshire Bathaway (or WB"), a large and very successful conglomerate in New York. You cannot believe your good fortune at working and learning at such...

Please read the questions Question: 1. ) Share a time when you witnessed or experienced deficit model thinking in the classroom AND/OR share an example of a time when you witnessed or experienced an...

Please read the questions Question: Think of an asset or strength-based approaches in chapter 4. Again, be specific and explain how these are examples of asset/strength-based thinking explain why? 4...

You have just been made our nation's adviser. The president wants to increase output by 400 by decreasing taxes. Your research assistant tells you that the mpe is .8, and all other components of...

We can take the approach to selecting a prior distribution for a population proportion p proposed in Exercise 11 one step further. Recall that the variance of a beta random variable, Y, is given by...

Question 2 6 . 6 7 pts Which option indicates the average minimum amount of urine a heallty individual produces hourty? 1 0 0 1 0 1 5 3 0

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...