Share
Explore BrainMass

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

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

Attachments

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

Solution Summary

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

$2.19