Question

Problem with weighted averages/percentages

Answer 1

I have information about fuel mileage, and total gallons used. I have information about average fuel mileage and percent of miles driven derived from total. I need to figure out how to calculate average fuel mileage in city conditions, and average mileage in highway conditions. information already obtained is
Total miles driven
Miles driven (city)
Miles driven (highway)
Fuel added (this fillup)
Avg fuel mileage (total)
% Miles driven (city)
% Miles driven (highway)

Answer 2

city miles/total miles is percent driven in city right?

Answer 3

yes

Answer 4

mileage highway will be higher than mileage city

Answer 5

id assume that the percent driven in the city would be ratioed to the avg fuel mileage .... maybe

Answer 6

\begin{array}l\color{#681766}{\normalsize\text{w}}\color{#755595}{\normalsize\text{i}}\color{#287695}{\normalsize\text{t}}\color{#996136}{\normalsize\text{h}}\color{#835696}{\normalsize\text{o}}\color{#469436}{\normalsize\text{u}}\color{#575523}{\normalsize\text{t}}\color{#889994}{\normalsize\text{ }}\color{#691253}{\normalsize\text{a}}\color{#721396}{\normalsize\text{n}}\color{#289287}{\normalsize\text{y}}\color{#786351}{\normalsize\text{ }}\color{#759965}{\normalsize\text{n}}\color{#864192}{\normalsize\text{u}}\color{#652813}{\normalsize\text{m}}\color{#354939}{\normalsize\text{b}}\color{#736388}{\normalsize\text{e}}\color{#112663}{\normalsize\text{r}}\color{#628149}{\normalsize\text{s}}\color{#547833}{\normalsize\text{ }}\color{#864392}{\normalsize\text{t}}\color{#546163}{\normalsize\text{o}}\color{#459722}{\normalsize\text{ }}\color{#323732}{\normalsize\text{w}}\color{#785453}{\normalsize\text{o}}\color{#847643}{\normalsize\text{r}}\color{#337481}{\normalsize\text{k}}\color{#618218}{\normalsize\text{ }}\color{#438239}{\normalsize\text{w}}\color{#343636}{\normalsize\text{i}}\color{#394667}{\normalsize\text{t}}\color{#694112}{\normalsize\text{h}}\color{#869984}{\normalsize\text{ }}\color{#312898}{\normalsize\text{i}}\color{#611669}{\normalsize\text{t}}\color{#611383}{\normalsize\text{s}}\color{#521596}{\normalsize\text{ }}\color{#493748}{\normalsize\text{h}}\color{#568954}{\normalsize\text{a}}\color{#629532}{\normalsize\text{r}}\color{#148278}{\normalsize\text{d}}\color{#627387}{\normalsize\text{ }}\color{#573469}{\normalsize\text{t}}\color{#111695}{\normalsize\text{o}}\color{#587186}{\normalsize\text{ }}\color{#765113}{\normalsize\text{w}}\color{#288243}{\normalsize\text{o}}\color{#431368}{\normalsize\text{r}}\color{#688527}{\normalsize\text{k}}\color{#219423}{\normalsize\text{ }}\color{#824629}{\normalsize\text{f}}\color{#136673}{\normalsize\text{r}}\color{#854951}{\normalsize\text{o}}\color{#867746}{\normalsize\text{m}}\color{#126455}{\normalsize\text{ }}\color{#493776}{\normalsize\text{t}}\color{#845965}{\normalsize\text{h}}\color{#937223}{\normalsize\text{e}}\color{#912329}{\normalsize\text{ }}\\\color{#551953}{\normalsize\text{a}}\color{#213799}{\normalsize\text{b}}\color{#963973}{\normalsize\text{s}}\color{#479829}{\normalsize\text{r}}\color{#472339}{\normalsize\text{a}}\color{#498562}{\normalsize\text{c}}\color{#828664}{\normalsize\text{t}}\color{#921767}{\normalsize\text{ }}\color{#591254}{\normalsize\text{.}}\color{#813837}{\normalsize\text{.}}\color{#352196}{\normalsize\text{.}}\color{#288891}{\normalsize\text{}}\end{array}

Answer 7

well, total avg mileage is ~ 37mpg.....so highway must be above that, and city must be below that. I need to figure out what each of those would be by way of a weighted equations.

Answer 8

weighted tends to use a relative frequancy distribution right?

Answer 9

say the vehicle goes 500 miles total. 267 city and 233 highway. if avg mileage total is 37.4, how do I figure out mileage per each?

Answer 10

i believe. in truth, I haven't been in a math class in about 4 years. And my books seem to have much missing. many things are now alien to me.

Answer 11

i cant recall too much of this either :)

Answer 12

youve got 2 variables; and your probability would be miles(37.4)

Answer 13

yeah, this has got to go into an excel spreadsheet. All I need is an equation, but one that excel would be able to figure out.... thats the hardest part of all this. lol

Answer 14

its one of those distribution tables ... i just cant see which one to use :)