Purchase Solution

Lines Excel

Not what you're looking for?

Ask Custom Question

This problem has you compare various linear functions.
a) Enter formulas for the 5 different linear functions which can be filled down that will output the appropriate y-value for the given x-values.
b) What is the y-intercept of each function? Answer should be a number.
c) Which slope from the 5 different linear functions will give he largest y-value for x=-1.5? Answer should be a number.
d) Will a positive of negative slope cause the graph to move downward from left to right? Answer should be the word positive or negative.
e) Make a singe scatterplot (connect the dots) showing all 5 lines.

Attachments
Purchase this Solution
Solution Summary

All formulas, computations, charts and solutions are in the Excel file.

Solution provided by:
J Pye, MSc
Education
  • MSc, California State Polytechnic University, Pomona
  • MBA, University of California, Riverside
  • BSc, California State Polytechnic University, Pomona
  • BSc, California State Polytechnic University, Pomona
Recent Feedback
  • "Excellent work. Well explained."
  • "Can you kindly take a look at 647530 and 647531. Thanks"
  • "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
  • "GREAT JOB!!!"
  • "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Probability Quiz

Some questions on probability

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

View More Free Quizzes
Related BrainMass Solutions

  • U.S. retail trade industry

    An Excel file with the graphs of the regression lines and computations is provided.

  • Outline of a cash flow statement (line items, no amounts)

    For each cash flow statement, some of these lines would not be used. And, for the indirect method, you may need other lines, depending on the current assets and liabilities of the firm. Your tutorial is attached in Excel.

  • marginal condition

    See the attached excel : Total Cost = $17,462,500 (c)What is the total cost to the distributor if all 200,000 cell phones are produced on lines 1 and lines 2, where the production shares between line 1 and line 2 are distributed to minimize the total

  • XY Scattergraph using Microsoft Excel

    142637 XY Scattergraph using Microsoft Excel I need an XY scatter graph using Microsoft Excel that has 30 for a maximum y axis and 4 for a maximum X axis. The numbers on the x-axis are offset with the numbers 0, 2, and 4 on the lines.

  • CVP graph; breakeven point

    See the graphs and examples given in excel. Formulas are in cells. ------------ See the graphs and examples given in excel. Formulas are in cells.

  • Linear Programming using Excel to for two products in two lines

    644165 Linear Programming using Excel to for two products in two lines A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours.

  • Based on the characteristics described in the case study, wh

    Based on the characteristics described in the case study, what other lines of business do you think vets would excel in? Why?

  • create a histogram

    The bar chart (histogram) is on the page in Excel. I don't know how to add lines to an Excel chart so I put it in manually. The bar chart (histogram) is on the page in Excel.

  • Cost Accounting - Choosing a Text Plan...create a graph

    The lines closest to activity levels requested are highlighted so you can see the cheaper plan.

View More Related Solutions