Question

How to find the missing/remaining values of a table from spreadsheet ( casio class pad 330) ??????

Answer 1

@amistre64 @phi

Answer 2

ive never worked with a casio class pad so i would not know exactly

Answer 3

did something or someone corrupt some data in a spreadsheet?

Answer 4

no, not that data lol
I'm talking abt u know how sometimes we are given a table with only 1 or 2 values, just to get us started on filling out the values of the table

spreadsheet, finds those values

Answer 5

if we are only given 2 values, then the best we can assume is a linear relationship to fit a curve to. but thats all thats going on in my head at the moment.

if given enough terms, and if its 'well behaved' then we can usually assess a pattern as well.

Answer 6

can i draw out my table here, to help me out ?

Answer 7

you can give it a shot :)

Answer 8

i have to determine the maximum profit

Answer 9

looks like we can multiply the first 2 columns to find revenue, and the difference between revenue and profit is expense. to see if there is some consistency about it

Answer 10

yeah, it looks from the sparse data available that expenses are a constant 5000

Answer 11

we can determine a relationship now between cost and tickets sold, 3 points form a parabola

Answer 12

yh but in order to find the values i have to find any formula

Answer 13

use the first 2 columns as data points for a quadratic equation:

ap^2 + bp + c = sold ; p for price,

Answer 14

using a matrix to solve the system of equation that is produced is simple enough; not sure how to do it for your calculator tho

Answer 15

i know how to do it manually but i just wanted to do it by calc, as well

Answer 16

find the matrix option and insert the values of p^2 p^1 p^0 and sold

(1)^2 (1) (1) (20000)
(1.5)^2 (1.5) (1) (17500)
(2)^2 (2) (1) (15000)

then do an rref operation on it to read off the values for a,b,c of the quadratic

Answer 17

http://www.wolframalpha.com/input/?i=rref%7B%7B%281%29%5E2%2C%281%29%2C%281%29%2C%2820000%29%7D%2C%7B%281.5%29%5E2%2C%281.5%29%2C%281%29%2C%2817500%29%7D%2C%7B%282%29%5E2%2C%282%29%2C%281%29%2C%2815000%29%7D%7D

hmm, 0, -5000, 25000 so i guess it was linear :)

Answer 18

thank you

Answer 19

so i get, number sold = (-5000p + 25000)

revenue is just number sold time price: p(-5000p+25000)

and profit is revenue minus expenses: p(-5000p+25000) - 5000

and that produces the quadratic i was thinking of

Answer 20

the vertex gives us the max profit/ticket price ... which is x=5/2, or 2.50