# Goal Seek; Frequency Distributions, Histograms and Probability Analysis; Joint Probability

Not what you're looking for?

Find the roots of x2 + 3x - 39 using Goal Seek

For the following frequency distribution:

a. Plot the frequency distribution

b. Calculate E(x)

c. Calculate P(x2)

d. Calculate P(x<=400)

x freq

150 3

300 8

400 6

450 4

650 2

900 1

1020 1

Problem 5

Use the entries in the following table to develop the applicable Joint Probability Table

Classes

Taught By Professors Assoc Prof Asst Prof Total

Seniors 2921 2298 1414 6633

Juniors 5899 15250

Sophomores 2227 2428

Freshmen 42 131 65 238

Total 11089 5512 28977

##### Purchase this Solution

##### Solution Summary

Goal Seek; Frequency Distributions, Histograms and Probability Analysis; Joint Probability are investigated. The solution is detailed and well presented.

##### Solution Preview

Please see the attached file for the complete solution.

Thanks for using BrainMass.

Q1. Find the roots of x2 + 3x - 39 using Goal Seek

Ans

Here we have solve x2+3x-39 =0

This can be written as x2+3x = 39

Goal Seek solution Steps

Step1.: Put any value in cell A1

Step 2: Enter the formula =A1*A1+3*A1 in B2

Step 3: Call Goal Seek from Tools menu

The details are given below

Answer x = 4.922617

For the following frequency distribution:

a. ...

##### Purchase this Solution

##### Free BrainMass Quizzes

##### 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

##### Multiplying Complex Numbers

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

##### Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

##### Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts