Purchase Solution

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

Not what you're looking for?

Ask Custom Question

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

View More Free Quizzes
Related BrainMass Solutions

  • Central Limit Theorem/Sampling Distribution

    To make histograms in Excel, you first have to make frequency distributions. Then make bar charts with the intervals on the x-axis and the frequencies on the y-axis. You are supposed to make histograms using sample means as your data.

  • Descriptive, Graphical and T-Test Using SPSS

    Complete the same analysis using University as a grouping variable. Paste your output into your assignment Word document (you do not need to paste the Frequency Table).

  • Statistical Analysis: Job Satisfaction

    [I have provided three different Frequency Distributions and Histograms so that you can decide among them which one to use. The Cross-Tabulation has been provided in the last sheet]. . The solution discusses job satisfaction.

  • How the following statistical devices can be used in business today?

    The major use of probability theory in business is in risk assessment and in trade on commodity markets. This includes portfolio analysis , decisions on investing assets and securities (e.g percentage of debt and equity).

  • Joint Probability Distributions

    188929 Joint Probability Distributions Determine the value of c that makes the function f(x,y) = c(x+y) a joint probability density function over the range: x greater than 0 and less than 3 and x less than y less than x+2 a) P(X<1, Y<2) b) P(1

  • Statistics - Probability Distribution

    188599 Joint Probability Distributions - The time between surface finish problems in a galvanizing process is exponentially distributed with a mean a 40 hours.

  • Probability and Frequency Distributions

    121688 Probability and Frequency Distributions 14. Due to rising medical costs, 43 million people in the United States go without medical insurance.

  • Joint and Marginal Probability Distributions

    Joint and marginal probability distributions are investigated. The solution is detailed and well presented.

  • Moment Generating Function, Marginal & Conditional Distribution

    (h) Find covariance and correlation coefficient, 3. The joint probability density function for random variables X and Y is: (a) Sketch fXY. (b) Find the marginal distributions of X and Y.

View More Related Solutions