ایمیل پشتیبانی خرید: [email protected]

تابع PERCENTILE.EXC

این تابع مقداری که بیانگر K امین صدک یک مجموعه از داده است را باز می‌گرداند (به طوریکه صدک 0 و 100 در نظر گرفته نمی شود).

شرح تابع PERCENTILE.EXC

درجه اهمیت تابع: کاربردی

تابعPERCENTILE.EXC یک مقدار که نمایانگر K امین صدک از یک مجموعه داده است را محاسبه می کند. به این معنی که این مقدار محاسبه شده نشانگر آن است که %k از داده ها کوچکتر از این مقدار خواهد بود. نوشتار این تابع به صورت زیر است:

=PERCENTILE.EXC( مجموعه اعداد, k)

ورودی های این تابع به شرح زیر هستند

مجموعه اعداد:  یک بازه از سلول ها (یک آرایه) حاوی اعداد است که می خواهیم صدک آن را محاسبه کنیم.

k: یک مقدار عددی بین صفر و یک (صفر و یک شامل نمی شود) است که می خواهیم مقدار صدک را محاسبه کنیم.

آنچه که تابع باز می گرداند

تابع PERCENTILE.EXC یک مقدار باز می گرادند که نمایانگر صدک یک مجموعه از داده ها است.

نکات

  • توجه شود که مقدار k باید بین صفر و یک (صفر و یک نباید شامل شود) باشد که این عدد رو می توان به صورت اعشاری (مانند ۰.۲۵) یا به صورت درصدی (مانند ۲۵%) وارد کرد.
  • این تابع از اکسل ۲۰۱۰ به بعد تعریف شده است و در نسخه های قدیمی وجود ندارد.
  • برای اطلاعات بیشتر در خصوص صدک ها و آمار توصیفی به دوره آموزشی«آمار توصیفی و تحلیل داده ها با اکسل» مراجعه نمایید.

مثال های تابع PERCENTILE.EXC

مثال ۱

در زیر ما صدک های مختلف را بر روی دامنه سلول های ستون A محاسبه کرده ایم.

 

برای یادگیری نرم افزار اکسل به صورت کاربردی به دوره «آموزشی اکسل کاربردی» رجوع شود.

برای یادگیری برنامه نویسی به زبان VBA به دوره «آموزش VBA در اکسل» مراجعه نمایید.

خطاهای معمول

#NUM! : در صورتی که مقدار k بین صفر و یک نباشد یا مجموعه داده تعریف شده خالی باشد.

#VALUE! : در صورتی که مقدار تعبیه شده برای k عدد نباشد.

۳ responses on "تابع PERCENTILE.EXC"

  1. PCT helps your body get well from the stress
    of cycling steroids and keep the positive aspects acquired during the cycle.
    In this section, we’ll discuss the optimum dosage for Winstrol and Anavar cycles from my expertise.
    It’s necessary to remember that individual responses to these substances could differ,
    and it’s always finest to consult with a healthcare skilled earlier than starting
    a cycle. The key to a profitable Winstrol and Anavar cycle is discovering the correct dosage
    and duration for my particular body type and goals.
    By starting with a lower dose and considering changes primarily based
    on my progress, I can achieve the nice results I’m looking
    for with out compromising my long-term well being.

    Anavar also can influence blood sugar levels, so those with diabetes should exercise caution. All The Time
    inform your physician about any drugs or supplements you’re taking to keep
    away from dangerous interactions. One of the core effects of Anavar is its
    ability to advertise muscle progress.
    This powerful supplement is made with natural components
    that work collectively to promote increased protein synthesis
    and nitrogen retention, which helps within the improvement of lean muscle mass and energy.
    Many ladies use it to enhance their athletic performance or to attain a certain body aesthetic.
    In the next sections, we’ll delve into the potential side effects of Anavar in females.

    Instead, it functions by mirroring its effects definitely,
    however that’s the place the bromance typically
    ends. Anavar, the revered steroid, doesn’t play favorites in terms of side effects –
    men and women both can get a taste. But, these unwanted
    aspect effects don’t essentially express themselves similarly for both genders.

    Other individuals really feel that natural steroids are a better alternative as a end result of they are not as
    more likely to trigger side effects. If you may be contemplating taking Anavar at the aspect of TRT, it may be very important
    speak to your physician in regards to the risks and advantages.
    Your doctor can help you to find out if Anavar is best for you
    and can help you to develop a protected and efficient therapy plan. They can assess your individual circumstances,
    hormone levels, and well being issues to determine if it is applicable
    for you and create a tailored plan. TRT is
    a long-term therapy and it is necessary to discuss the dangers and benefits
    with your physician earlier than starting therapy.
    It is a medical remedy that entails the alternative of
    testosterone in males who’ve low levels of the hormone.

    A extra frequent aspect effect in our experience when taking Anavar is menstrual irregularities or amenorrhea (cessation of the month-to-month period).
    Moreover, consuming a diet high in unsaturated fats while proscribing saturated fats can help scale back cardiovascular strain on Winstrol.
    Both of those methodologies have improved ldl cholesterol ratios in research (7)
    and in our exams. Thus, we don’t find ALT and AST markers, symbolizing potential
    liver stress or injury, rising excessively high on Anavar.

    To add to this, Winstrol’s status for inflicting typically
    very severe joint ache isn’t a identified issue with Primobolan. Many imagine Primobolan is healthier suited to women than Winstrol
    is and, in general, should have fewer unwanted facet effects.

    Primobolan additionally is available in oral and injectable varieties and, like Winstrol, is a DHT-based steroid.
    This means no aromatizing and no estrogenic effects
    like water retention.
    This combination proved extremely helpful after they had been looking for
    that final touch to sculpt or tone their bodies. The customers observed a substantial reduction in physique fats and appreciated the preservation and even enhancement of
    muscle mass, attributing this optimistic change to the potent duo.

    Nevertheless, in addition they caution that the effectivity of those substances didn’t give them a cross to slack off on their nutrition or coaching.
    The cycle that features each Anavar and Winstrol typically begins with smaller dosages of both
    substances to gauge the body’s preliminary
    response. The dosages might then be progressively
    elevated, however all the time with the utmost heed.
    In basic, the Anavar part of the cycle is meant to give consideration to boosting strength and total
    endurance while Winstrol primarily helps in fat reduction and
    muscle tightening.
    Winstrol poses the next liver toxicity and facet effect risk than Anavar,
    so we are ready to keep this stack brief.

    Doses are round half that of what we’d normally use for every compound as a outcome of they’re both oral steroids.
    At a minimum, all male customers might want to stack Anavar with testosterone at a base TRT dosage to avoid the
    effects of low testosterone because of Anavar’s suppressive
    activity. If Anavar is getting used as part of an extended
    contest prep cycle, it’s going to usually be saved for the final weeks of
    the cycle to get you as lean and shredded as potential.
    We may compare Anavar with a protracted listing of AAS and different PEDs
    if you’re making an attempt to choose the most effective compound on your next
    cycle. Here, I want to concentrate on lining it up in opposition to
    two different popular cutting steroids, plus a
    well-known fat burner.
    The use of Anavar, like all anabolic steroid, can carry potential dangers and side effects, including liver toxicity,
    cardiovascular issues, and hormone imbalances. As little as 5 mg to 20 mg daily could possibly be helpful whereas mitigating potential unwanted aspect effects
    like voice deepening or physique hair progress,
    which are undesirable for many women. Remember, Oxandrolone’s efficiency
    allows even modest doses to have substantial results.
    One major use of anavar results in bodybuilding is throughout a
    slicing part. Due to its capability to preserve lean muscle
    whereas selling fat loss, it helps bodybuilders to take care of bulk without sacrificing definition.
    However, most research have checked out short-term use, and people have
    assumed that much less toxic implies that it won’t
    result in liver failure in any respect. Anavar was once used
    to promote growth in children, however now growth hormones are extra generally
    used for this objective. From my time in the ring, I’ve seen how
    Anavar boosts muscle growth and bone development. One Other facet effect particular to girls is clitoral enlargement, which can be everlasting.
    Ladies may also expertise a decrease in breast measurement because
    the body’s hormonal balance shifts. Unlike different steroids
    that require excessive doses and complex injection schedules, Anavar is straightforward—but that doesn’t mean you’ll find a way to take any dose
    and expect excellent outcomes.
    Nevertheless, you will want to note, people ought to
    adhere to the really helpful dosage and use the supplement
    responsibly to count on these sorts of transformations.

    After all, like another health complement, Oxandrolone is handiest when paired
    with a balanced food regimen and a rigorous workout routine.
    As with all such choices, it’s important to take gradual steps, adjusting based on private experience rather than rushing to succeed in optimum dosage quickly.
    Keep In Mind, the target is not just about gaining muscles, but in addition ensuring holistic wellness.
    Whilst indications point in path of the Oxandrolone tablets being mild on the physique, it’s important to recollect everyone is exclusive.
    Starting sluggish provides time to look at and perceive
    how the physique is responding, as results can differ throughout individuals and gender.
    To ensure security and maximise benefits, sourcing these tablets from reputable vendors
    is all of the extra necessary.

    References:

    seriods (Carlton)

  2. Additionally, a comprehensive strategy that focuses on general sexual well being may
    be useful. This may include incorporating way of life modifications such as regular train, a balanced food plan, and stress management strategies.
    Consulting with a healthcare professional or specialist
    in sexual health can present priceless insights and personalized recommendations.
    Moreover, Anavar also can affect the cardiovascular system,
    which plays an important role in erectile function. By altering blood circulate and blood stress, Anavar can influence
    the ability to achieve and maintain an erection.
    They present customized steering, making certain any use of Anavar or different remedies aligns with your health targets
    and circumstances. It’s not just about selecting a treatment; it’s about harmonizing medical recommendation with private aspirations for well being and wellness.

    With hormones, precision is key—oversight from a healthcare provider ensures that every step
    in path of revitalization is supported by proof and experience.
    As men age, sustaining optimal testosterone levels turns into
    a challenge.
    Additionally, many people might grapple with mental health challenges related to body picture issues that originally drove them
    to steroids. These factors can complicate the process of
    quitting Anavar independently. The vary of Anavar’s unwanted
    aspect effects can differ significantly from one individual to a different.
    Furthermore, users could develop both psychological and physical drug dependence, which can alter mind chemistry and lead to compulsive utilization. You can discover some great Earlier Than and after pictures online, with some very
    beautiful accomplishments with Anavar solely cycles.
    A lot of the photographs are of folks who used Anavar to lower their physique fats, some to get a extra outlined look, and others to extend muscle strength and firming.

    When you buy Oxandrolone (Anavar) you are shopping for a hepatotoxic androgenic-anabolic steroid.
    What this means is that Anavar is metabolised primarily
    by your liver. You will be ready to obtain a lean, vascular, dry muscle mass while the visceral fat round your belly area
    might be reduced when you mix Oxandrolone (Anavar) with exercise.
    This steroid medication will help you in building lean, dry,
    vascular skeletal muscular tissues. You don’t have to worry about fluid
    retention with this drug and the visceral fats round your stomach area shall be considerably decreased when you mix
    your workout classes with OxaGen 10.
    They typically start inside the first week of taking the drug and should final for several weeks.
    As a end result, customers of Anavar could discover that their sex
    drive decreases significantly whereas taking the drug. Lastly, some folks merely have a
    delicate abdomen and can’t tolerate the excessive doses of Anavar
    required to see outcomes. If you expertise nausea
    whereas taking Anavar, strive decreasing your dose or
    taking it with meals. For most individuals, although, the aspect impact is simply short-term and can resolve as soon as they stop taking
    Anavar. In the meantime, there are some steps that could be taken to assist handle the situation, together with utilizing non-comedogenic cleansing merchandise
    and avoiding unnecessarily touching the face.

    With most steroids, performance doses shall be significantly higher
    than those used clinically or medically. However, with Proviron, we can often get its complete benefits even at the lowest medical dosage
    vary. Even low doses can present some great vascularity12, and it will build upon any
    effects you achieve with different AAS in the cycle.
    Whereas overall muscle hardness, pumps, and vascularity won’t be as good as
    Winstrol or Masteron, Proviron can be used longer without the liver toxicity of the other chopping steroids.

    Anavar, an artificial anabolic steroid, can affect various
    bodily methods and should work together with different medications.
    According to Medicine.com, there are 102 known drug interactions with oxandrolone, some of
    which could be severe. Given the stress Anavar locations on the liver,
    combining it with other liver-toxic drugs, corresponding to acetaminophen or sure antifungal medication, may heighten the chance of liver harm.

    The vitality wanted to contract your muscles comes from ATP (adenosine triphosphate).
    Nonetheless, your muscular tissues solely include enough ATP to offer vitality for a quantity of
    seconds of movement. This means that for continuous muscle contraction, you want more ATP.
    When lifting weights, you want extra ATP, which is saved in phosphocreatine, which helps quickly regenerate
    the ATP you have to present a burst of power.
    The downside to oral testosterone is that it is notably dearer than injectable testosterone.

    With Anavar additionally being a expensive compound,
    this cycle can value tons of of dollars. Individualized remedy programs delivered in a cushty, relaxed setting promote healing in your recovery journey.
    Nonetheless, remember that ladies can react far more delicate to hormones than males are probably to do, and
    due to this fact ought to take the Anavar in a lot smaller quantities.
    As we said, blood pressure will have quite an impact in your kidneys –
    they’re filters in any case. Now, one other issue that will also
    make your kidneys ‘oof’ is the fact that Anavar is mostly digested by the kidneys.

    If you’re anxious about losing any hair on Anavar/Testosterone –
    you presumably can complement with a DHT-blocking
    supplement corresponding to Finasteride or Saw Palmetto.
    Grapefruit juice inhibits CYP3A4, enabling extra of a substance to enter the bloodstream.

    However, if a girl has suffered from liver harm
    before or consumes giant quantities of alcohol, then Anavar (and other steroids) should be avoided.
    This is problematic for women because Dianabol greatly increases the possibilities of virilization. Thus, tests are really
    helpful and can be bought for a cheap value on-line. Many girls who are
    thinking of taking steroids are afraid of their bodies altering, ultimately trying like a man. This is called
    virilization – when a girl begins to develop manly options.
    In which case, if ladies did start to discover decreased breast measurement (for example), they may decrease their dose to stop further virilization.
    Fish et al (2008) measured alcohol-induced aggressive motivation by
    responses on an FI-10 schedule within the residence cage.
    We just lately utilized this mannequin to review AAS-induced aggressive motivation (Wood et al, 2013).
    As A Result Of response charges for an estrous female beneath FI-10 had been relatively modest, we subsequently developed
    a 2nd-oder FR task primarily based on Everitt
    et al (1987).
    Due To This Fact, suppression will nearly at all
    times be a difficulty on a cycle that includes Proviron, necessitating PCT (see my
    PCT section above for extra information). Anavar is a relatively mild oral steroid, though Proviron is milder in most areas.
    Greater confidence and motivation and an overall “feeling great” mood are widespread experiences with Proviron. So a lot so
    that a patent was submitted (now expired) that states Proviron has “neuropsychotropic activity” with an curiosity in utilizing it as a melancholy treatment13.
    You’re not alone if you’ve learn that Proviron was developed and released within the 1930s.
    A generally circulated fable is that Mesterolone is among the very oldest
    steroids created. Nonetheless, the truth is slightly different… Mesterolone didn’t exist
    till the Nineteen Sixties.

    References:

    anabolics.com

  3. Understanding the differences between Anavar and Dbol is crucial when selecting the best
    performance-enhancing substance on your health goals. Whereas Anavar is thought for its capacity to help customers obtain lean muscle mass and energy, Dbol’s primary focus is on promoting substantial muscle growth and energy.
    Anavar, also known as oxandrolone, is one other synthetic anabolic
    steroid commonly utilized in bodybuilding to advertise muscle
    progress and fat loss, as properly as to improve power and endurance.
    Anavar works by rising protein synthesis, much like Dianabol, however it’s considered to be a milder steroid with
    fewer unwanted aspect effects. However, Anavar can still trigger potential
    risks similar to liver toxicity and decreased testosterone ranges.
    When considering using any anabolic steroid, it is essential to
    concentrate on potential side effects and risks.

    Nonetheless, its potent effectiveness can even result in more pronounced side effects compared to Anavar.
    Anavar is understood for its low androgenic activity and
    reasonable anabolic results, which contribute to its functionality to advertise muscle
    progress without vital side effects. This steroid
    is commonly favored for its minimal impression on liver toxicity and its capability to keep up lean muscle mass.
    Dianabol is a robust steroid that is typically utilized by beginners or first-timers trying to get a hold of steroids or anabolics.
    It not solely steps up protein synthesis in your physique but
    in addition enhances nitrogen retention resulting in fast muscle features.
    Extra usually than not, first timers are likely to acquire as a
    lot as 20-30lbs of physique weight with the primary cycle itself and nearly 30% of
    that is alleged to be water weight. Extra water is often misplaced as quickly as
    you are off-cyle, making you seem leaner and muscular.

    Anvarol is a natural complement designed to duplicate the consequences of
    Anavar without the dangerous unwanted effects. It promotes fat burning and helps preserve lean muscle throughout cutting cycles.
    Anvarol’s key ingredients include ATP (adenosine triphosphate) and BCAAs (branched-chain amino acids), which enhance vitality and
    support muscle recovery. This is because anabolic steroids also affect a woman’s hormones, with their endogenous testosterone ranges
    declining. In this cycle pattern, the Anavar dose of 20 mg/day is maintained for 8 weeks.
    This dose is often adopted by people who’ve previously taken Anavar or different anabolic steroids.

    Nonetheless, we should do not neglect that even a 4-week cycle of Anavar can produce outcomes, which is able to hold costs down somewhat.
    Other nations are considerably less strict concerning
    possessing Anavar on your personal use. The
    UK, Canada, Denmark, Finland, Sweden, and Norway are just a few international locations with
    more relaxed anabolic steroid laws. This permits us
    to gain insight into how totally different individuals experience Anavar.
    This offers you a noticeable enhance in power, in addition to elevated endurance
    and stamina. Anavar likely also will increase ATP, instantly
    contributing to more strength and endurance37. Hopefully, nobody out there
    thinks you probably can take a steroid after which sit back along with your feet up, eating chocolate cake all
    day, anticipating to transform into Vin Diesel magically.

    Dianabol will spike testosterone levels (initially), which
    is a strong fat-burning hormone. You can see that a few of the old
    bodybuilders who’ve come off steroids can shrink dramatically.
    Nevertheless, a big proportion of this muscle loss could be attributed to them having stopped lifting weights.
    We have found that when a person comes off Dianabol, they may typically lose anywhere from 20–۵۰%
    of their muscle measurement. Thus, a major proportion of the
    results are permanent ought to users proceed lifting weights.
    Elite female bodybuilders can take high doses of 10–۲۰ mg; nevertheless, such users can expect to expertise
    masculinization effects. AIs have additionally been proven to be advantageous when mixed with SERMs for restoring
    testosterone production.
    Nonetheless, we find it could take several months for a user’s
    testosterone ranges to return to normal. Analysis reveals pure endogenous
    check production is restored after 4–۱۲ months upon discontinuation (19).
    Injectable Dianabol is an choice for these who don’t need to experience liver issues when taking this steroid.

    Dianabol is often an oral steroid; nonetheless, there are
    veterinary versions of it obtainable that could
    be injected, instantly getting into your bloodstream and bypassing
    the liver. Nonetheless, we discover injectable Dianabol to be less
    widespread on the black market, with orals being the more
    normal type of administration. A frequent incident of
    moobs in males is the outcomes of extreme chest fat, which may be corrected via fats loss and
    muscle-building workouts concentrating on the pectoral area.
    If bloating or water retention turns into extreme, users ought to decrease the
    dose or discontinue use.
    Regardless Of its effectiveness, Dianabol comes with
    a excessive risk of androgenic unwanted effects, such as pimples, hair loss, and
    elevated physique hair progress. It can be liver toxic when taken orally, and extended or high-dosage use
    can stress the liver. These steroids mix to kind a powerful stack that may amplify body strength and improve muscle mass significantly.

    I never do over 40 mg on orals because back pumps are annoying,
    and never greater than four weeks. I’ve been on 60 mg cut
    up over 3 occasions a day for 4 weeks, and I’m getting some decrease again pain, stomach pain, and a very dark yellowish urine.
    The Anavar dose beneath reflects a cautious dose utilized by our feminine sufferers.

    By selling the synthesis of creatine phosphate inside the muscles, it helps to extend
    muscular endurance and power without the added water weight.
    This makes it an interesting selection for athletes taking part in weight-class sports or people centered on attaining a more aesthetic and outlined physique.
    Dbol’s impression on strength and endurance is
    well-regarded among athletes and fitness fanatics.
    The steroid’s androgenic properties contribute to elevated purple blood cell manufacturing and improved oxygen-carrying capacity.
    This allows for enhanced muscular endurance, enabling people to
    perform more repetitions, maintain intense exercises for longer
    periods, and push through bodily limitations. Additionally,
    Dianabol will increase muscle glycogen shops, providing the body
    with available power throughout intense training periods.
    As a result, users usually report substantial strength gains
    and the flexibility to raise heavier weights, contributing to overall enhancements in bodily performance.

    Nonetheless, it can also trigger unwanted aspect effects such as water retention, hypertension, and
    liver toxicity. Despite its outstanding benefits,
    Dianabol (Dbol) isn’t with out its potential unwanted effects.
    Customers could experience a spread of adverse reactions, each
    short-term and long-term. In the quick term, Dbol can cause water retention, leading to bloating and weight acquire.

    Research has proven that the bioavailability of oral
    testosterone is roughly 50% decrease when taken on an empty stomach (1).
    This cycle is typically solely utilized by males as a result
    of testosterone causing virilization unwanted effects in girls.
    We sometimes observe virilization side effects steadily occurring and exacerbating over a sustained period of time.
    A girl should discontinue her cycle if she begins to expertise any unwanted signs.
    These real-world experiences underline the efficiency and
    potential dangers of Dbol. Whereas Anavar and Dianabol can significantly
    improve your physique, know that they don’t come without side reactions.

    References:

    how do Steroids Affect the body

Leave a Message

نشانی ایمیل شما منتشر نخواهد شد. بخش‌های موردنیاز علامت‌گذاری شده‌اند *

© دیاکو دانش افزار.
X