代写QUESTION 1帮做R编程

QUESTION 1

1. READ ALL OF THESE INSTRUCTIONS FULLY - DO NOT SKIP THIS! THESE INSTRUCTIONS APPLY TO ALL PROBLEMS SETS

•     You are required to submit MS Excel to support every answer you report   in every problem set. An explanation for what is meant by using MS Excel to accomplish your work is located in the course syllabus. Please be sure

you read that to be sure you show your work correctly.

•     The truncation of values used in your calculations will result in a

deduction of 50% credit from the question. What does this mean? Say

you calculate "=11/3" in cell A1 and it returns 3.666        . You also

calculated "=14/9" in cell A2, which returns 1.555        . You now need to  multiply these two numbers. The correct method is to calculate "=A1*A2"

which returns 5.7       . If you truncate and type values into a new formula, such as "=3.667*1.556" it would return 5.705852, which is an incorrect

answer. If you were to continue to calculate using this incorrect value, you will likely end up with much more error in your answer and end up using

incorrect values to make decisions. Even if your truncated calculation

returns the correct answer to the designated number of decimal places, you will receive the deduction due to the potential for future calculation  error. You must use the Excel calculation tools to determine all of your   answers.

•     This question, and question 1 on all other problem sets, is where you will upload your MS Excel file.

•     Only one file can be uploaded, so be sure all of your work is consolidated into one Excel file. If you need assistance on how to create additional

worksheets in your MS Excel workbook, please view the Excel Demo - Excel Basics video again.

•     Please be sure the question number and answer are clearly marked in your worksheet.

•     If you have used Data Analysis, please place your output in the same worksheet as the data.

•     Data values/sets may be different on subsequent attempts. You will be

graded based on the data values/sets of the last attempt.

• You will not receive credit for any problem for which you do not show your work - even correct answers.

Remember, these instructions apply to all problem sets!

If you have any questions about these instructions, please post it to the

Discussion Board under "Course Administration Questions for Dr. Leach" or send your question by email.

9.    Attach File

0 points

QUESTION 2

1.   The average test scores in the Scholastic Assessment Test (SAT) for college-   bound seniors was recorded for each year from the 1966-67 to 2015-16 school  years (download here:SAT scores.xlsx). Provide charts to answer the following questions:

1.    Have critical reading and mathematics scores for all students changed much over the years?

2.   Are there differences in test scores between the genders?

Format each chart with chart title, axis titles and legend. Upload the file containing the charts and the answers to the questions.

3.    Attach File

10 points

QUESTION 3

1.   There is a concern at universities that undergraduate students are taking too

many courses in one semester. To investigate this issue, the number of courses taken during the current semester was collected from a random sample of 250

enrolled undergraduate students from each class year (download

here:Courses.xlsx). (Class Year: 1=freshman, 2 =sophomore, 3=junior, 4=senior)

1.   Create a pivot table for these data. Format the pivot table with the category names for class year.

2.    From the pivot table, create a pivot chart presenting the number of

students in each class year that take each number of courses. Format the pivot chart with chart title, axis titles, legend and data labels.

Upload the file containing the pivot table and pivot chart.

3.    Attach File

10 points

QUESTION 4

1.    New England consists of six states. The 2021 population of the New England

states are provided in the fileNE State Population.xlsx. Provide a pie chart for New England state populations. Present the pie chart formatted with data labels identifying the state name and percentage of total New England state

population. Upload the file containing the pie chart.

1.    Attach File

10 points

QUESTION 5

1.   The top ten most populous states in 2020 consisted of 53.5% of the total

population of the United States. We have recorded the population of each state from 2010 and 2020 (download here:Top Ten State Populations.xlsx). To

analyze how these ten states have grown between 2010 and 2020, create the following two charts:

1.   A column chart of state populations for both 2010 and 2020. Format the

chart with chart titles, axis titles, and legend. Be sure to present the data in order from largest to smallest by 2020 population.

2.   A column chart of percentage growth of population from 2010 to 2020.  Format the chart with chart titles, axis titles, and data labels. Be sure to present the data in order from largest to smallest population growth.

Upload the file containing your two column charts.

3.    Attach File

10 points

QUESTION 6

1.   A statistics professor gave his students a 60-minute quiz and recorded the

amount of time to complete the quiz for each student in a class of 390 students (download here:Test time.xlsx). Draw a histogram of the time to complete the   quiz. Use a bin width of 1 minute. Be sure your graph is formatted to include a  chart tile and axis titles. Provide a description of the shape of the

histogram. Upload the file containing the histogram and description of its shape. 1.    Attach File

10 points

QUESTION 7

1.    Undergraduate students studying industrial engineering are required to take

calculus as a prerequisite for their statistics course. A sample of 21

undergraduate industrial engineering students was drawn. The course grades for

calculus and statistics were recorded for each student (download

here:Grades.xlsx). To analyze the relationship of grades in calculus and

statistics, draw a scatter diagram of the data. Format the chart with chart title,

axis titles and truncate each axis to remove empty spaces from your chart. What conclusion does the scatter diagram lead you to regarding the relationship

between grades in calculus and statistics? Upload the file containing the scatter diagram and conclusion.

1.    Attach File

10 points

QUESTION 8

1.    Using theGSS2018.xlsxdata set, answer the following questions:

A. How many people provided a response for hours worked per week (variable: HRS1)? (report your answer as an integer)

B. What is the mean age of the respondents (variable: AGE)? (report your answer to 2 decimal places)

C. What is the median income of the respondents (variable: INCOME)? (report your answer as an integer)

D. What is the variance of the number of children of the respondents (variable: CHILDS)? (report your answer to 2 decimal places)

E. What is the standard deviation of the years of education of the respondents (variable: EDUC)? (report your answer to 2 decimal places)

F. What is the mode of the marital status of the respondents (variable: MARITAL)? (report your answer as an integer)

G. What is the covariance between age (variable: AGE) and marital status (variable: MARITAL)? (report your answer to 2 decimal places)

H. What is the coefficient of correlation between the number of children (variable: CHILDS) and education level (variable: EDUC)? (report your answer to 4 decimal places)

I. 80% of the respondents are younger than what age when they have their first child (variable: AGEKDBRN)? (report your answer as an integer)

J. What is the third quartile for the age of the respondents (variable: AGE)? (report your answer to 2 decimal places)