Excel Assignment

DS 312 Fall21 Excel Assignment# 1

Posted on Monday 9/27/2021 at 9:00 am

Due: Friday 10/1/2021 at 11:59 pm

INSTRUCTIONS:

· This assignment accounts for 7% of the final grade. It consists of data analysis and software exercises. Use Excel to analyze the data.

· Type all your answers in a single MS word document. Copy and paste relevant Excel output reports, graphs, and/or tables in the same document. You need not retype the questions, but label your answers with the question numbers, e.g., 1.1)_____

· When done, upload and submit the word file via iLearn assignment. Please name your file DS312 Excel assignment#1-LastnameFirstname.

· Please keep the Excel file containing all of your analyses and results. You may be asked to submit it later.

· You can not collaborate, consult, or receive help from anyone. If you have any question, please ask me, not a classmate. Late or missed submission will be counted as a zero.

· You will be graded based on the completeness and correctness of your answers. Simply submitting the Excel output and/or plot without any explanation will not be sufficient.

QUESTIONS & TASKS:

Question 1:

1.1. Determine which variable should be the independent variable (X) and the dependent variable (Y).

1.2. Develop a scatter plot between X and Y and comment on the type of relationship between the two variables.

Question 2:

2.1 Perform the simple regression analysis using Excels regression function. What is the regression equation for the problem? Submit the summary output report.

2.2 Comment on the strength of the relationships between X and Y. Is X a good predictor of Y? Explain.

Question 3: Conduct residual analysis to determine whether there is any violation of the main assumptions of the regression model. Comment on the results of the analysis. Submit all the graphs used to test the assumptions.

Questions 4 -6 will be in the context of the data set assigned to you. Please see the questions below.

Dont just provide the final answers. You must show intermediate calculations leading up to the final answers.

For data set #1 (GPA)

The director of admissions of a small college selected 120 students at random from the new freshman class in a study to determine whether a student’s grade point average (GPA) at the end of the freshman year can be predicted using the ACT test score.

Question 4: Obtain a point estimate of the mean freshman GPA for students with ACT test score of 30. Question 5: Construct a 98% confidence interval for the mean freshman GPA for students whose ACT test score is 30.

Question 6: Mary Jones obtained a score of 28 on the entrance test. Construct a 90% prediction interval of her freshman GPA.

For data set #2: (Copier Maintenance)

The Tri-City Office Equipment Corporation sells an imported copier on a franchise basis and performs preventive maintenance and repair service on this copier. The data have been collected from 45 recent calls on users to perform routine preventive maintenance service. The company would like to use these data to predict the total number of minutes spent by the service person using the number of copiers serviced.

Question 4: Obtain a point estimate of the mean service time on calls in which 80 copiers are serviced.

Question 5: Construct a 98% confidence interval for the mean service time on calls in which 80 copiers are serviced

Question 6: The store receives a call to repair 75 copiers today. Construct a 90% prediction interval for the service time on this call.

For data set #3: (Airfreight Breakage)

A substance used in biological and medical research is shipped by airfreight to users in cartons of 1,000 ampules. The data below, involving 10 shipments, were collected. The objective is to predict the number of ampules found to be broken upon arrival using the number of times the carton was transferred from one aircraft to another over the shipment route.

Question 4: Obtain a point estimate of the mean number of ampules broken in 16 transfers.

Question 5: Construct a 98% confidence interval for the mean number of ampules broken in 16 transfers.

Question 6: The next shipment will entail 20 transfers. Construct a 90% prediction interval for the number of broken ampules for this shipment.

Our Service Charter

1. Professional & Expert Writers: Homework Free only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Homework Free are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Homework Free is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Homework Free, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.