Please help me to approach this question with excel:
Which of the term of the sequence 3/16, 3/8, 3/4, ..., 96 is the last given term?
I work in the custom cabinetry and millwork business and would like to know how involved or difficult the following Excel task might be:
I've developed a spreadsheet which calculates part sizes for wood cabinet doors. (Inputs are the door heights and widths, together with a family of parameters specific to the particular door style. These values plug into formulas which then generate the part sizes.) My spreadsheet is working fine so far, but I would like to incorporate diagrams into the output. As a first step, a typical diagram would be a simple line drawing of a cabinet door, which is basically just a set of concentric rectangles that I would want to be sized and scaled to be an accurate proportional representation of each door. To be clear, no matter what the actual size of the door is, each diagram should be scaled to fill an allotted space on the printed page. The diagram would need to be dimensioned, with the dimensions themselves coming from the output of the spreadsheet. How would you recommend I accomplish this? If it's helpful, I'm using AutoCAD also.
Short of actually having excel draw the diagram to perfect proportional scale, I wonder if a sensible work-around might be that I create a large number of AutoCAD-drawn dummy door diagrams which cover a wide range of possible door sizes and shapes. Excel could choose the dummy diagram which comes closest to matching the proportions and part widths for a given door. It wouldn't be perfect, but given enough of a selection (several hundred dummy diagrams maybe), it might be close enough for my purposes. I'm not sure if this is a simpler solution? Even if it is, I don't really have any idea how to dimension each diagram automatically. The dimensioning should look like a dimension you would find on any architectural drawing, with little lines "snapping" to the end points, a long dimension line connecting them, with the value written in the middle.
Thanks -- hope this all makes sense!
Hi Lords and Ladies!
I was wondering if there are any statistical tools in excel?
What I need is a comparison program to do the following:
Column A: abcdefgh
Column B: bcaghfrnreo
Column C: 80% match (roughly)
Is that possible to do in excel?
Regards,
Don Defy
Morning All,
Does anyone know of a free tutorial that can explain how to get statistical data in Excel? - I have seen it done before (in excel) for 'Linear regression', I am wondering if the same can be done for "Polynomal"?
Rgs
Neville
I have a data set based on an uneven distribution of cards in a 60 card deck, each with a value ranging from 0-5.
I need to build a probability distribution of all the random samples of 10. So, how many random sets of 10. have an average value of 1 (or a total of 10) etc.
Then, I need to build a variable distribution so that it changes as I change the sample size. So, with a sample of 20 cards, what does the distribution look like?
Can this be done in excel? Should I post what I have now to work with?
I am having difficulty setting up a Excel sheet for the following problem.
An industrial Engineer at ABC Products wants to determine whether there are more units produced on PM shift then AM Shift.
Sample of 54 Am workesr with a mean number of units produced is 345 with a standard deviation of 21.
Sample of 60 PM workser with a mean number of units produced is 351 with a standard deviation of 28 units.
Significance level is .05
Trying to figure out if the PM shift is larger.
Hi everyone, first thanks for the help.
I am trying to create a histogram and let me explain some of the data.
I have a list of data separated like so:
3.5
3.6
3.8
3.8
3.9
3.9
etc...
Now I need to calculate the frequencies of these like so:
3.5 (up to but not including) 4.0
4.0 (up to but not including) 4.5
I can count out the frequencies myself but i need to create a histogram (bar graph) with the y axis as the frequency and the x axis as the IMR(infant mortality rate: ie the 3.5 (up to but not including) 4.0).
I am having problems with calculating the frequencies because when setting the bin values because they include 4.0.
If this is confusing I can provide some more information, but cannot find a good tutorial that would create a histogram anywhere remotely close to the histogram i drew by hand.
Hi,
I was hoping someone could help me with this particular statistics+excel problem that I cannot solve, or, at least need some confirmation that I am solving it correctly...
MY DILEMMA: Let's say I am asking people to choose their favorite letter(s) ranging from a-vvv (1-100). I ask 9 people to choose their favorites, but they can't choose more than 100 #'s (obviously since a-vvv represents 100 letters). Once I gather the information, the only way I know how to create the proper order is to AVERAGE the data by inputting zero into the fields/letters that were not chosen (since no one chose all 100 letters). My question is... HOW DO I PROPERLY ORDER THE "LETTERS" FROM MOST TO LEAST POPULAR BASED ON THE SUBMISSIONS??? I realize this is a statistics problem, but I'm hoping something efficient can be done in excel.
I've also attached the working excel file to use as a working document. Feel free to PM if you would like to attach an excel file.
Thanks in advance everyone!
-Ryan
what is the best geometric mean formula for a short list of positive and negative returns? thank you!
