iSixSigma

regression using excel

Six Sigma – iSixSigma Forums Old Forums General regression using excel

Viewing 15 posts - 1 through 15 (of 15 total)
  • Author
    Posts
  • #41521

    george2
    Participant

    Hi all,
    i am pasting in some output per day data.  My question is can someone tell me how to perform a regression analysis using excel so that i can predict future demand?  we are making on a daily basis what we require and i have excess capacity.

    01-Nov
    12,820

    02-Nov
    24,087

    03-Nov
    23,449

    04-Nov
    19,220

    05-Nov
    10,500

    06-Nov
    19,500

    07-Nov
    9,046

    08-Nov
    30,739

    09-Nov
    16,742

    10-Nov
    10,996

    11-Nov
    25,245

    12-Nov
    0

    13-Nov
    13,500

    14-Nov
    17,249

    15-Nov
    20,045

    16-Nov
    9,500

    17-Nov
    19,849

    18-Nov
    34,934

    19-Nov
    3,230

    20-Nov
    17,500

    21-Nov
    32,500

    22-Nov
    15,019

    23-Nov
    17,653

    24-Nov

    25-Nov

    26-Nov

    27-Nov

    28-Nov

    29-Nov

    30-Nov

     

    0
    #130279

    Mikel
    Member

    Regression is contained in the add-in called analysis toolpack and will show up under tools>data analysis

    0
    #130285

    Rahman
    Participant
    #130308

    Ron Brown
    Member

    If you are trying to conduct a multiple regression analysis, you cannot use Microsoft Excel, you will need to use Minitab. Excel can only help you with a linear regression analysis.
    Try the Minitab site, it is better than Excel and you can download a free trial for 30 days.
    http://www.minitab.com/resources/Articles/BURRIL2.aspx

    0
    #130314

    Mikel
    Member

    Not true – you can definitely do multiple regression with Excel.
    I do agree that Minitab is better.

    0
    #130318

    Ron Brown
    Member

    I do not know how to do it. Can you please show me.Regard.

    0
    #130321

    Ken Feldman
    Participant

    Look in the Help section for the LINEST function. 

    0
    #130323

    Scippy
    Member

    Excuse me for a most tangential interruption kind and helpful Dr. D., I believe that you once said that W. Edwards Deming was on your dissertation committee in an interdisciplinary doctoral program.   Also you mentioned one of the fine universities in Florida amongst other interesting factoids.   It is very possible though that I have jumbled several of your messages into one completely misunderstood and or faultily recalled wrap of originally posted text and my own imagined metadata and subtext.
     
    But I can’t seem to get a fix on you using UMI ProQuest Digital Dissertations (and I mean the licensed version available in university libraries that go way back versus the free internet version that only goes back two years) and other search tools.   Reckon why that is?   As a trained and practicing member of the Society of Competitive Intelligence Professionals (SCIP) I am usually very proficient in the fine art of search. 
    Skippy 

    0
    #130326

    Ken Feldman
    Participant

    Dear Esteemed Skippy,
    Thank you for your interest in ancient history.  Me thinks one needs a hobby if that is your idea of a fun adventure.  The year was 1984 A.D.  I am not sure what search criteria you used since you didn’t have the title and it is obvious that a name search for Darth will likely not reveal many citations.  Feel free to contact me offline at [email protected] and we can see how to get to the bottom of this mystery.  I would be glad to send you a copy of the dissertation or a copy of the signature page if you intend to include it in Dr. Phil’s SickSigma Xmas Catalog.

    0
    #130331

    Dr. Phil
    Participant

    Dr. Darth;
    This is not the same Dr. Phil who usually contributes to meaningless threads and attempts to start trouble here. He only gets 15 minutes out of his cell now. 
    I am a trained medical doctor and I am treating a patient, and I am hopeful that since you are busy answering questions and helping people with their various needs, especially with the answer, “Look to your left for the blue bar and ‘New to Six Sigma’, we may get your assistance.
    Not to mention interest in a Sunday hobby of unearthing ancient scrolls bearing the meaning of middle-life academic writings as the bell rings and Skippy plays another round of “My Work was more Rigorous  than Yours was”. 
    Might you may be available to consult on a serious medical problem I am treating in my practice?
    We have a patient, let’s call her Mellonhead Marge, who has an unusual device stuck on her head, something like a giant coffee cup, or what some may see as an upside down bathroom fixture.
    Said headpeace is stuck, on her elongated cerebrum, contributing to trauma and misalignment of her ears, and lockjaw. Our staff cannot seem to locate the pressurized flushing device, if one is self-contained.
    She has also developed a fondness for Def Lepard piped in, as the sound is amplified in the cavernous acousically perfect environment.
    Please don’t suggest acetaminophen, as we have tried it.
    Please don’t suggest the GiaMedProCo’s division manufacturing a utility plunger device, as said headpeace allow’s no entry for tool usage.
    Since the holiday’s are coming up, and this poor woman wants to go shopping for the latest in import items at the local big box store, we have run out of alternatives. She doesn’t want to miss out on the big sales this week.
    Standing by, (no actually sitting, and may not even consider by) waiting for your response, a fellow member of the AMA.    Dr. Phil, sans the Xmas Catalog. (that will come sometime next month)

    0
    #130332

    Ken Feldman
    Participant

    Dr. Phil, please note that there is nothing about the aforementioned physical condition that prevents your patient from engaging in moderate shopping activity.  See below.

    If your patient is still inclined to rid herself of her condition because of possible social stigma while visiting the local big box store, the literature suggests that the following treatment be employed.  Good luck.

    0
    #130333

    BLOCKED
    Participant

    ~BLOCKED~

    0
    #130340

    Skippy
    Member

    Winny,
    Oh, 1984, yes that was the key search term missing.    It was indeed a remarkable study.  Sorry to have appeared to have doubted your academic prowess.   It was not that at all, I was merely searching for [sort of a quality management interdisciplinary thing +”W. Edwards”] and without the year there were too many close calls.  And “Wynand” I did not have.   Thanks.
    Skippy 
     

    0
    #130341

    Dr. Phil
    Participant

    Dr. Darth: Thanks for your consultation. I never thought to review the literature, as I usually just make this up as I go. Thanks for all of your research and for posting the dual how-to guide.Will indicate on this poor woman’s grossly inflated medical bill that additional charges for your assistance are required, and due payable in cash. Just another day in the life of a professional healthcare pickpocket. If I could get by installing a series of expensive GiaMedProCo products in her, I would……..in a heartbeat.Whoooops, got to go, I don’t want MC or Frank to redirect all this shop talk to the Healthcare Channel. Your colleague in the AMA and a graduate of the finest medical school in Turkmenistan, Dr. Phil.Have a great week, everybody!

    0
    #131064

    Khadijatou
    Participant

    Based on the data you provided, you cannot conduct a regression analysis. A regression is done to determinee the correlation between magnitudes, so you need at least two sets of data and you only provided one.

    0
Viewing 15 posts - 1 through 15 (of 15 total)

The forum ‘General’ is closed to new topics and replies.