Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please i need corect answear i need q1 4. The excel questions must be done in excel and a clear snapshot of excel sheet must

please i need corect answear

i need q1

image text in transcribed

4. The excel questions must be done in excel and a clear snapshot of excel sheet must be pasted in submission file. 1. (1pt) Consider the following two equations y=3x+1y=3x5 Draw a joint graph of both lines using excel. What do you observe about the orientation of these lines? Why would you expect this result from the equations of the lines themselves? Show the complete formula in the snapshot of excel sheet. 2. (1pt) In a factory, the production hours t and output y are having linear relationship. When the factory operates for 5 hours per day, it may have the number of outputs of 2000 units and 3500 units for 8 hours of operation. (a) Model an equation that gives the outputs, y, in terms of operation hours, t, per day. (b) If the factory wants to have 4500 units of production per day, how long it should operate? (c) Draw the graph in excel of the production against operation hours t up to first 20 hours. 3. (1pt) The demand function for a product is P=5Q+150, where P is the price (in SR) per unit when Q units are sold (per month). The variable costs are 15 per unit and the fixed cost are SR200. a) Draw a ioint oranh of the total revenue and the total cost in excel ( keen O between 0 4. The excel questions must be done in excel and a clear snapshot of excel sheet must be pasted in submission file. 1. (1pt) Consider the following two equations y=3x+1y=3x5 Draw a joint graph of both lines using excel. What do you observe about the orientation of these lines? Why would you expect this result from the equations of the lines themselves? Show the complete formula in the snapshot of excel sheet. 2. (1pt) In a factory, the production hours t and output y are having linear relationship. When the factory operates for 5 hours per day, it may have the number of outputs of 2000 units and 3500 units for 8 hours of operation. (a) Model an equation that gives the outputs, y, in terms of operation hours, t, per day. (b) If the factory wants to have 4500 units of production per day, how long it should operate? (c) Draw the graph in excel of the production against operation hours t up to first 20 hours. 3. (1pt) The demand function for a product is P=5Q+150, where P is the price (in SR) per unit when Q units are sold (per month). The variable costs are 15 per unit and the fixed cost are SR200. a) Draw a ioint oranh of the total revenue and the total cost in excel ( keen O between 0

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

The Social Media Handbook For Financial Advisors

Authors: Matthew Halloran

1st Edition

1118208013, 978-1118208014

More Books

Students also viewed these Finance questions

Question

How do amplifiers differ from repeaters?

Answered: 1 week ago