Create a chart in Excel that is a scatterplot of mileage (x-axis) and price (y-axis)…. 1 answer below »

. Create a chart in Excel that is a scatterplot of mileage (x-axis) and price (y-axis). Add the regression line, the regression equation, and the r-squared (in Excel, R2) value to the chart. Copy it from Excel and paste it into Word. Write a brief summary (1 paragraph) of what the chart indicates about the relationship between the two variables. Identify any outliers that you see.
V. Calculate a 95% confidence interval (CI) for both of the two variables (price and mileage). In your report, state the 95% CI for both variables and provide a brief written summary (1 paragraph) interpreting the CI’s.
VI. Copy the results of the simple linear regression hypothesis test that you conducted in Excel and paste them into Word.
VII. Write a detailed summary (3 – 4 paragraphs) of the results explaining what they mean and how they answer the question listed in part I. State whether you rejected the null hypothesis in favor of the alternative hypothesis or whether you failed to reject the null hypothesis, including the F-value and p-value for your test and your interpretation of these values. Report the Pearson correlation coefficient (r) and the goodness of fit (r2) and interpret what they tell you about the relationship in terms of strength of the correlation between the variables and the fit of the line to the data, respectively. State the linear regression equation y = a + bx + e, using price as y and mileage as x (b is the regression coefficient for mileage, which comes from the Excel output).
VIII. Conclusion: Briefly summarize (1 paragraph) what you did for this project and what you determined about the relationship between mileage and price of a used car of a particular make, model, and year. Make sure that your summary clearly answers the question asked in part I.

Attachments:

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Compare and contrast aa and pahoehoe lava in appearance and how they form.ReferencesLutgens, F. K.,

Compare and contrast aa and pahoehoe lava in appearance and how they form.ReferencesLutgens, F. K., & Tarbuck, E. J. (2014). Foundations of Earth science (7th ed.). Upper Saddle River, NJ: Pearson.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Complete the following chart for different sequencing rules. Sequencing Rule Job Arrival Date Job Du

Complete the following chart for different sequencing rules.

Sequencing Rule
Job Arrival Date Job Due Date FCFS EDD
A 146 162
B 137 167
C 145 156
D 140 152
 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Find all solutions to the given system by eliminating one of thevariables. 1. 3X1 + 5X2 = 4 2X1 -7X2

Find all solutions to the given system by eliminating one of thevariables. 1. 3X1 + 5X2 = 4 2X1 -7X2 = 13 2. 10X + 4X2 = 2 15X1 – 6X2 = -3 . . .

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I was on vacation in Germany. Now the tenant – IP address owner – received a letter (his name as… 1 answer below »

I was on vacation in Germany. Now the tenant – IP address owner – received a letter (his name as the recipient) from Waldorf Frommer that there was an illegal file uploading of a Warner Bros. movie during my stay. I didn’t upload any illegal file ever as far as I recalled. But now I have no evidence to prove my innocence; I was alone in the house at the time. The tenant mentioned that there were several people knowing his wifi password ***** me…I’m not German and I’m not living in Germany also. Are German laws effective on me? How should I go around with this? Does he have to point out a person to take responsibility or does he just have to prove that he was not in town at the time? In the worst scenrio that we have to pay, but as studenta we don’t have money to afford the fine, can we submit a statement to prove so?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

A firm tries to improve the waiting process for its customers. They collect the following…

A firm tries to improve the waiting process for its customers. They collect the following information: On average, 40 customers arrive every hour. On average, it takes 5 minutes to serve one customer There are 4 employees available for service. The firm studies 2 options for the design of the waiting space:

I) Making one line for each employee, thus having 4 different waiting lines

II)Placing all customers in one waiting line, and the customer at the front of the line is served by the first employee available. Assume that the distributions for inter- arrival times and service times are exponential.

a)Which option results in the shortest waiting time in the queue? Motivate your answer. b) If there is no money available to hire an extra employee, how can the customer waiting process be improved?

Attachments:

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

An employee earned $61,600 during the year working for anemployer. The FICA tax rate for Social Secu 1 answer below »

An employee earned $61,600 during the year working for anemployer. The FICA tax rate for Social Security is 6.2% of thefirst $118,500 of employee earnings per calendar year and the FICAtax rate for Medicare is 1.45% of all earnings. The current FUTAtax rate is 0.6%, and the SUTA tax rate is 5.4%. Both unemploymenttaxes are applied to the first $7,000 of an employee’s pay. What isthe amount of total unemployment taxes the employee must pay? $101.50 $56.00 $378.00 $434.00 $0.00 . . .

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

3. When a company makes a product or service internationally, it must formulate a number of business

3. When a company makes a product or service internationally, it must formulate a number of business decisions called

a. marketing mix

b. marketing goals

c. marketing strategies

d. marketing branding

4. In an international skills inventory, tolerance and sensitivity to others is called

a. adaptation skills

b. coping skills

c. work effectiveness skills

d. intercultural communications skills

6. Translation services, interest charges, metric labelling requirements, and local taxes are part of

a. retail value

b. hidden costs

c. the exporter’s fee

d. the importer’s fee

9. When a multinational company (MNC) seeks total integration of its global operations, it is

a. ethnocentric

b. polycentric

c. geocentric

d. regiocentric

10. The rules of correct or appropriate behaviour when meeting with officials or business people are called

a. manners

b. common sense

c. guidelines

d. protocol

12. Which of the following is a particular challenge for a global company?

a. maintaining quality product standards throughout the company’s facilities

b. saving on raw materials and labour

c. ability to market a product worldwide

d. worldwide access to knowledge and ideas

13. Political risk can take the form of which of the following?

a. financial gain

b. increased market share

c. technical breakdown

d. all of the above

16. When you are underpaid, you are paid enough to live on.

a. True

b. False

19. The process of using natural resources, materials, or finished products to satisfy human wants or needs is called…. (Standard I-International Business Vocabulary and Definitions)

a. Export

b. Consumption

c. Resources

d. Trade

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

When writing C++ programs include comments in your code, make the program readable by indenting, use

When writing C++ programs include comments in your code, make the program readable by indenting, use meaningful variable and function names, give end users instructions on what the program does and produce meaningful output.

Program: 20 points – triangle.cpp

Write, test, and debug a program that prompts the user for 3 sides of two triangles.  Your program will be written using a Triangle class and will have 2 Triangle objects (variables/instances of the class).  

 

You will need to write a method (member function) that saves those sides to private object variables, write another method(s) to return the side(s), write another method to return the perimeter, write another method to return the area.  This means you will have a minimum of 4 methods in your program, you might have more depending on how you write the methods that save/return the sides.

 

Perimeter: a + b + c  // triangle sides are a, b, c

Area:

#include // you will need to include this for the square root function

sqrt(((a+b+c)/2)*(((a+b+c)/2)-a)*(((a+b+c)/2)-b)*(((a+b+c)/2)-c)); // Heron’s Formula

 

Example program run:

 


This program will take the 3 sides of two triangles and calculate the perimeter and area

 

Please enter 3 sides of triangle 1:   16   14    10.5

Please enter 3 sides of triangle 2:   6     7.5    9

 

The triangle 1

       with sides of 16, 14, 10.5

       has a perimeter of 40.5

       and has an area of 72.4185

 

The triangle 2

       with sides of 6, 7.5, 9

       has a perimeter of 22.5

       and has an area of 22.3235

    • Posted: 4 years ago
    • Due: 09/10/2015
    • Budget: $40
     

    "Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"