+ Reply to Thread
Results 1 to 2 of 2

How to use sigma problem for multiple server excel

Hybrid View

  1. 04-06-2016, 06:38 PM #1
    vivejohn
    vivejohn is offline
    Registered User
    Join Date
    04-06-2016
    Location
    New York City, New York
    MS-Off Ver
    None
    Posts
    1

    Post How to use sigma problem for multiple server excel

    Hi,

    I'm new to the forum but am looking for help in Excel. My problem for my business course (image attached) is how to find Po (Probability no customers are in the system) given the average arrival rate, average service rate, and number of services. My main problem really is how to use sigma in excel with factorials and right parentheses in the right places. Any help would be appreciated! Thanks.

    J
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 04-06-2016, 06:49 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: How to use sigma problem for multiple server excel

    Welcome to the board.

    Create named ranges L, u, and k

    Create named formula n refers to: =ROW(INDIRECT("1:" & k-1)) - 1

    Then

    Row\Col
    A
    B
    C
    1
    		 L
    6
    2
    		 u
    5
    3
    		 k
    3
    4
    		 P0
    0.316456
    		 B4: {=1/SUM( (L/u)^n / FACT(n) + (L/u)^k / FACT(k) * (k * u) / (k * u - L))}


    The curly braces mean that the formula MUST be confirmed with Ctrl+Shift+Enter instead of just Enter.
    Last edited by shg; 04-06-2016 at 06:53 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sigma Sum function with multiple variables
    By MVictorH in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2015, 10:08 AM
  2. Multiple Sigma's working correctly in one formula
    By Ernst88 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-15-2014, 01:24 PM
  3. Excel add-in for SQL Server Analysis Services - Merge and Center problem
    By mclifford in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2007, 03:39 PM
  4. Excel Hyperlink gives error cannot find internet server or proxy server
    By athens61 in forum Excel General
    Replies: 1
    Last Post: 04-26-2007, 10:36 PM
  5. Repost Excel Server Problem
    By shattarjain@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2005, 04:05 AM
  6. [SOLVED] problem updating link from Novell server to windows server #REF er
    By Ellen in forum Excel General
    Replies: 0
    Last Post: 05-10-2005, 05:06 PM
  7. Excel Add-in for SQL Server Analysis Services - refresh problem
    By Inge M. Bruvik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2005, 04:07 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1