Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This exercise will use the data file Collegeratings.xls. Description of the Data College ratings contains data on course evaluations, course characteristics, and professor characteristics for

This exercise will use the data file Collegeratings.xls.

Description of the Data

College ratings contains data on course evaluations, course characteristics, and professor characteristics for 200 courses for three academic years at a fictitious university.

Estimate a regression of Course_Eval on Beauty, Intro, OneCredit, Female, Minority, and NNEnglish. Which of the following statements is false?

(a)Beauty is statistically significant at 5% level but not at a 1% level.

(b)Minority is statistically insignificant.

(c)A female instructor has a lower predicted course evaluation than a comparable male instructor.

(d)An instructor that is not a native English speaker (NNEnglish) has a predicted lower course evaluation than a comparable native English speaker instructor and this variable is statistically significant at a 5% level.

(e)None of the above.

course_eval

minority

female

onecredit

beauty

intro

nnenglish

age

4.4

0

1

0

1.509794

0

0

31

4.2

0

0

0

0.588569

0

0

62

4

0

1

0

-0.126

0

0

33

3.4

0

1

0

-0.25819

0

0

51

4.5

0

1

0

0.149693

0

0

33

3.9

0

0

0

0.540917

0

0

47

3.1

1

0

0

0.231613

0

1

35

4

0

0

0

-0.06667

0

0

37

3.8

0

0

0

0.216892

0

0

42

3.4

0

0

0

-0.2587

0

1

49

2.9

0

1

0

0.550288

0

0

37

4.5

0

0

0

-0.06204

0

0

45

4

0

1

0

-0.98239

0

0

56

3.8

0

0

0

-0.05434

1

0

48

4.3

0

1

0

-0.06801

0

0

46

3.4

0

1

0

0.029414

0

0

57

3.4

0

1

0

0.239486

0

0

52

3.3

1

1

0

-0.84873

0

1

29

4.3

0

0

0

-0.73309

0

0

62

4.4

0

0

0

-0.11112

0

0

64

4.6

0

1

0

1.775517

0

0

34

4.2

0

0

0

-0.32185

0

0

58

4

1

0

0

0.211694

0

1

52

3.3

0

0

0

-0.71765

0

0

73

4.4

0

0

0

-0.73269

0

0

70

2.3

0

1

0

0.408168

0

0

41

3.5

0

0

0

-0.01021

0

0

63

4.7

0

0

0

-0.92396

0

0

47

3.9

0

0

0

0.576681

1

0

39

4

1

1

0

-0.0836

1

0

47

4.3

0

0

0

-1.07956

0

0

54

3.8

1

1

0

1.040902

0

0

44

3.8

1

0

0

-1.05211

0

0

47

4

0

0

0

-0.72777

0

0

62

4.6

0

0

0

-0.3954

0

0

60

3.5

0

0

0

0.933396

0

0

37

4.7

0

0

0

-0.23778

0

0

42

4.2

0

0

0

0.274908

0

0

35

3.4

0

1

0

1.970023

1

0

39

3.9

0

0

0

1.05095

0

0

49

4.5

0

0

0

0.241819

1

0

61

4.7

0

0

0

1.349395

0

0

33

3.5

0

1

0

0.111564

0

0

58

3.7

0

1

0

-0.25773

0

0

56

4

0

1

0

-0.65627

1

0

50

4.1

0

0

0

-0.65639

0

0

52

4.4

0

1

0

0.724478

0

0

33

4.2

0

0

0

0.631834

0

0

57

4.5

0

1

0

1.070944

0

0

38

3.8

0

1

0

-1.45049

1

0

34

3.1

0

0

0

1.15588

0

0

34

3.7

0

0

0

-0.32601

1

0

32

3.9

0

1

0

0.884644

1

0

42

4

0

1

0

-0.55835

1

0

43

3.3

0

0

0

-0.34155

0

1

35

3.1

0

1

0

-0.50406

0

0

62

4

0

0

0

-0.90058

0

0

42

4.3

0

0

0

0.643014

0

0

39

3.7

0

1

0

0.773524

0

0

52

3.4

0

1

0

1.063938

0

0

52

4.3

0

1

0

-1.09039

0

0

52

3.7

0

0

0

-1.06916

0

0

64

4.2

0

0

0

1.415695

0

0

50

2.2

0

0

0

-1.42292

0

0

60

3

0

1

0

0.391822

0

0

51

4.3

0

0

0

-0.48996

1

0

43

4.6

1

0

1

-0.58359

1

0

50

3.5

0

0

0

0.756683

0

0

52

4.6

0

0

0

0.880819

1

0

51

3.7

0

0

0

-0.5665

1

0

38

3.8

0

1

0

0.339404

1

0

47

3.6

1

1

0

-0.15137

1

0

43

4.4

0

1

0

-1.025

1

0

38

4.1

0

0

0

-0.02524

1

0

43

4.3

0

0

0

-0.74679

0

0

57

4

0

1

0

0.988949

0

0

51

4.8

0

0

1

-0.53242

1

0

45

3.5

0

0

0

-0.76689

1

0

57

3.6

0

1

0

1.154256

1

0

47

3.8

1

1

0

1.232602

1

0

54

4.7

0

0

0

1.774334

1

0

58

4.9

0

0

0

1.773151

1

0

42

4.3

0

0

0

0.724593

1

0

33

3.3

0

0

0

-1.18163

1

0

62

3.4

1

1

0

1.769452

1

0

35

3.6

0

0

0

-0.58726

1

0

61

4

0

1

0

-0.00183

1

0

52

3.9

0

1

0

-0.05668

0

1

60

4.3

0

0

0

1.231394

1

0

32

3.3

1

1

0

0.4204

0

1

42

3.7

1

1

0

0.289916

0

0

36

3.6

1

1

0

0.289916

0

0

36

4.4

1

1

0

0.289916

0

0

36

4

0

0

0

-0.73773

0

0

59

2.1

0

0

0

-0.73773

0

0

59

3.2

0

0

0

-0.57198

0

0

51

3.5

0

1

0

-0.67796

0

0

40

4.1

0

1

0

-0.67796

0

0

40

4.6

0

1

0

-0.67796

0

0

40

3.8

0

1

0

-0.67796

0

0

40

3.8

0

1

0

-0.67796

0

0

40

3.8

0

1

0

-0.67796

0

0

40

4.2

0

1

0

-0.67796

0

0

40

3.9

0

1

0

1.509794

0

0

31

4.5

0

1

0

1.509794

0

0

31

4.5

0

1

0

1.509794

0

0

31

4.4

0

1

0

1.509794

0

0

31

4.4

0

1

0

1.509794

0

0

31

4.4

0

0

0

0.588569

0

0

62

4.5

0

0

0

0.588569

0

0

62

4.3

0

0

0

0.588569

0

0

62

4.6

0

0

0

0.588569

0

0

62

4.8

0

0

0

0.588569

0

0

62

4.3

0

0

0

0.588569

0

0

62

4

0

1

0

-0.126

0

0

33

4

0

1

0

-0.126

0

0

33

3.9

0

1

0

-0.126

0

0

33

3.3

0

1

0

-0.126

0

0

33

4.5

0

1

0

-0.25819

0

0

51

4.5

0

1

0

-0.25819

0

0

51

4.5

0

1

0

-0.25819

0

0

51

2.5

0

1

0

-0.25819

1

0

51

4.3

0

1

0

-0.25819

0

0

51

4.5

0

1

0

-0.25819

0

0

51

4.7

0

1

0

0.149693

0

0

33

3.5

0

1

0

0.149693

0

0

33

4.5

0

1

0

0.149693

0

0

33

3.8

0

1

0

0.149693

0

0

33

4.5

0

1

0

0.149693

0

0

33

4.3

0

1

0

0.149693

0

0

33

3.9

0

0

0

0.540917

0

0

47

4.3

0

0

0

0.540917

0

0

47

4.2

0

0

0

0.540917

0

0

47

5

0

0

0

0.540917

1

0

47

5

0

0

0

0.540917

1

0

47

4.6

0

0

0

0.540917

0

0

47

5

0

0

0

0.540917

1

0

47

4.7

0

0

0

0.540917

0

0

47

5

0

0

0

0.540917

1

0

47

2.7

1

0

0

0.231613

0

1

35

4

1

0

0

0.231613

0

1

35

4.4

0

0

0

-0.06667

0

0

37

4.4

0

0

0

-0.06667

0

0

37

4.3

0

0

0

-0.06667

0

0

37

3.5

0

0

0

-0.06667

0

0

37

3.8

0

0

0

0.216892

0

0

42

3.9

0

0

0

0.216892

0

0

42

3.7

0

0

0

0.216892

0

0

42

3.3

0

0

0

0.216892

0

0

42

4

0

0

0

0.216892

0

0

42

3.8

0

0

0

0.216892

0

0

42

4.2

0

0

0

-0.2587

0

1

49

3.1

0

0

0

-0.2587

0

1

49

3.6

0

0

0

-0.2587

0

1

49

3.3

0

1

0

0.550288

0

0

37

2.9

0

1

0

0.550288

0

0

37

3.1

0

1

0

0.550288

0

0

37

4

0

0

0

-0.06204

1

0

45

4

0

0

0

-0.06204

1

0

45

4.2

0

0

0

-0.06204

0

0

45

3.8

0

0

0

-0.06204

0

0

45

4.3

0

0

0

-0.06204

1

0

45

4.6

0

1

0

-0.98239

0

0

56

4.3

0

1

0

-0.98239

0

0

56

3.6

0

1

0

-0.98239

0

0

56

4.2

0

1

0

-0.98239

0

0

56

3.9

0

0

0

-0.05434

0

0

48

4.1

0

0

0

-0.05434

0

0

48

4

0

0

0

-0.05434

1

0

48

4.3

0

0

0

-0.05434

1

0

48

3.9

0

0

0

-0.05434

0

0

48

4.2

0

0

0

-0.05434

1

0

48

4.2

0

0

0

-0.05434

1

0

48

4.9

0

1

0

-0.06801

1

0

46

4

0

1

0

-0.06801

0

0

46

4.3

0

1

0

-0.06801

0

0

46

4.9

0

1

0

-0.06801

0

0

46

3.9

0

1

0

-0.06801

0

0

46

4.9

0

1

0

-0.06801

1

0

46

3.9

0

1

0

-0.06801

0

0

46

4

0

1

0

-0.06801

1

0

46

3.5

0

1

0

0.029414

0

0

57

3.9

0

1

0

0.029414

0

0

57

4

0

1

0

0.029414

0

0

57

3.6

0

1

0

0.029414

0

0

57

3

0

1

0

0.029414

0

0

57

3

0

1

0

0.029414

0

0

57

3.6

0

1

0

0.029414

0

0

57

3.6

0

1

0

0.029414

0

0

57

3.2

0

1

0

0.029414

0

0

57

3.9

0

1

0

0.239486

0

0

52

3.5

0

1

0

0.239486

0

0

52

3.5

0

1

0

0.239486

0

0

52

3.1

0

1

1

0.239486

0

0

52

4.2

0

1

0

0.239486

0

0

52

3.6

0

0

0

-0.73309

1

0

62

4.5

0

0

0

-0.73309

0

0

62

3.7

0

0

0

-0.73309

1

0

62

3.4

0

0

0

-0.73309

1

0

62

4.5

0

0

0

-0.11112

0

0

64

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Mathematics questions