第五題為什麼是B

5. The company's financial status has been excellent over the last three years, but even ------- revenues are expected in the future. (A) great (B) greater (C) greatest (D) greatly 6. The ------- in my neighborhood strives to provide the best possible service to his customers. (A) mechanic (B) mechanical (C) mechanism (D) mechanics

急‼️求解 （統計學） 要怎麼用excel做？？求怎麼解題的過程🙏🙏🙏

【題6】前程出版社今年每位業務員的平均業績為4千萬元,標準差300 萬元, 若該公司一共有 100 位業務員,請用經驗法則估計前程出版社今年有多少業務員的業 績介於3千4百萬到4千9百萬之間?(提示:請利用經驗法則)

（大ㄧ統計學） 請問這兩題要怎麼回答？？想知道要怎麼用excel來解答問題的過程🙏🙏🙏 QAQ急需要 謝謝🙏

【題8】根據某年台灣地區人口資料顯示,在有子女的家庭中,依子女人數分類之家庭分配 比例如下表所示: x f(x) 1 2 3 4 5 試求台灣家庭子女平均數(期望值) 男性 女性 15 0.05 0.15 0.25| 0.25 0.30| 1 男性 女性 總計(邊際機率) 【題9】某項針對性別對智慧型手機使用滿意度情況的調查如下表所示: 非常滿意 無意見 不滿意 非常不滿意 20 12 35 15 15 20 17 x*f(x) (1) 請製作 “聯合機率分配表”(包含邊際機率) 非常滿意 滿意 無意見 x2*f(x) 68 33 1 請問對手機使用感覺滿意的女性機率為何? ② 請問性別的邊際機率為何? 3 求手機使用情況的邊際機率分配表。 男 女 [回答] 1 2 (2) 交叉分析 請使用(1)資料說明交叉分析的實務操作 請問男性受訪者之中,使用滿意度的分布情況如何? 與變異數 ②② 請問女性受訪者之中,使用滿意度的分布情況如何? 若欲進行上述的交叉分析,則下表的比例(機率值)須為「列百分比」 非常滿意 |滿意 無意見 不滿意 非常不滿意 不滿意 6 非常不滿意 總計(邊際機率) 總計

（大ㄧ的統計學） QAQ請問這兩題的excel要怎麼做出來？求做出來的步驟（方法）🙏🙏🙏🙏🙏急需要🙏🙏🙏

【題6】前程出版社今年每位業務員的平均業績為4千萬元,標準差 300 萬元, 若該公司一共有 100 位業務員,請用經驗法則估計前程出版社今年有多少業務員的業 績介於3千4百萬到4千9百萬之間?(提示:請利用經驗法則) (Ch4 機率分配) 【題7】教育部為了瞭解目前在國內大學任教的教師工作壓力為何?依照壓力指標,10-15 分 屬於無壓力、16-20 分屬於低壓力、21-30 屬於中壓力、31-40 屬於高壓力、41 分以上屬於超 高壓力。下表是回收後的問卷所整理好的次數分配表,屬於高壓力或超高壓力的機率是多少? 總分群組 人數 相對次數 |10-15 16 | 16-20 |21-25 26-30 |31-35 | 36-40 |41-45 46-50 總和 6 32 30 78 80 238 120 P= 次數分配表與機率的關係: 5

（大ㄧ的統計學） QAQ請問這題要怎麼用excel做出來？？求做出來的步驟（方法）🙏🙏🙏🙏🙏🙏🙏🙏

【題5】(1)請計算(A 欄位)X資料的平均數,中位數、眾數、第1四分位數、第3四分 位數、百分位數、樣本變異數、樣本標準差 解答 1: |每月支出 (單位:千元) 32 15 8 25| 19 15 9 15 22 20| 排序資料 平均數 中位數 眾數 第1四分位數 第3四分位數 P70 P25 Pos (樣本)變異數 (樣本)標準差 解答 2: 請將 excel 的資料分析 output,放置於下方

想問3-9的a跟c

Problems 3-1. Explain the difference between *(a) random and systematic error. (b) constant and proportional error. *(c) absolute and relative error. (d) mean and median. *3-2. Suggest two sources of systematic error and two sources of random error in measuring the length of a 3-m table with a 1-m metal rule. 3-3. Name three types of systematic errors. *3-4. Describe at least three systematic errors that might occur while weighing a solid on an analytical balance. *3-5. Describe at least three ways in which a systematic error might occur while using a pipet to transfer a known volume of liquid. 3-6. Describe how systematic method errors may be detected. *3-7. What kind of systematic errors are detected by varying the sample size? 3-8. A method of analysis yields masses of gold that are low by 0.4 mg. Calculate the percent relative error caused by this result if the mass of gold in the sample is (a) 500 mg. (b) 250 mg. V(c) 125 mg. (d) 60 mg. 3-9. The method described in Problem 3-8 is to be used for the analysis of ores that assay about 1.2% gold. What minimum sample mass should be taken if the relative érror resulting from a 0.4-mg loss is not to exceed *(a) -0.1%? (b) -0.4%? (c) -0.8%? (d) - 1.1%? 3-10. The color change of a chemical indicator requires an overtitration of 0.03 mL. Calculate the error if the total volume of titrant is percent relative (a) 50.00 mL. (c) 25.0 mL. 3-11. A loss of 0.4 mg of Zn occurs in the course of an percent relative analysis for that element. Calculate the error due to this loss if the mass of Zn in the sample is *(b) 10.0 mL. (d) 30.0 mL. 190 (c) 188 (d) 4.52 x 103 4.63 x 103 4.53 x 10 ³ √6 *(a) 30 mg. (b) 100 mg. *(c) 300 mg. (d) 500 mg. 3-12. Find the mean and median of each of the following sets of data. Determine the deviation from the mean for each data point within the sets, and find the mean devi- Vation for each set. Use a spreadsheet if it is convenient. *(a) 0.0110 0.0105 (b) 24.53 0.0104 24.68 24.81 24.77 39.61 862 (f) 850 MA 3-13. Challenge Problem: Richards and W the molar mass of lithium and colle data. 24.73 Experiment 1 2 3 4 5 6 194 447 X 10 7 448 X 107 4.58 X 10 (a) Find the mean molar t workers. (b) Find the median molar ma (c) Assuming that the cam molar mass of lithium is the absolute ertor and of the mean value demi Willard. (d) Find in the chemical ues for the molar mus since 1910, and ag a table or spreadshera 1817 given in the a Richards and Willd. Com mass versus year to la of lithium has chang Suggest possible abruptly about 18 ant de (e) The incredibly deals Richards and W that major changes will occur. Disc calculation in pat (f) What factors ha since 1910? (g) How would you mass? 6See Chapter 2 of Applications of Microsoft Excel in Analytical Chemistry, 4th ed., for information about statistical 7T. W. Richards and H. H. Willard, J. Am. Chem. Soc., 1910, 32, 4, DOI: 10.1021/ja01919a002. built-in statistical functions. "Answers are provided at the end of the book for questions and problems marked with an asterisk The I of ₂ or inc rce of able vas error c often in individu ate resul data in rtainties. dimensio andom e analysts The result

求求解開求解過程跟答案 謝謝🙏

班級: 學號: 姓名: 以下題目請利用calc軟體計算求解,並將求解過程及最後答案貼至writer檔。 calc檔與writer檔同時上傳繳交。(若電腦系統為MAC,可使用excel與 Word處理。)檔名:作業1 姓名 1. Z為一標準常態分配,試求下列各式之a P(Z <a)=0.954 : (1) P(Z>0.7)=a ; (2) 2. o 台灣某鄉鎮共有居民100人。某次選舉,根據瞭解鄉民支持候選人A君的機 率約為50%,已知當天投票,全鄉鄉民全部出動,試問候選人A君的得票率 至少為55%的機率為何? 3. 假定某間女子學校有1200位女學生,其身高的分配近似於常態分配。在已 知其平均身高H=162 公分,標準差o=4公分的條件下,試求出 (1)約有多少位女學生其身高介於158公分與166公分之間? (2) 倘若隨機抽出36位學生,則在此36位學生當中,約有多少位學生其 身高介於161公分與163公分之間? 4. 設 XiX.…. X, 是常態分配 N(u,o?)的一組隨機樣本,且表其樣本平均 數。若n=20 時,X的標準差是2;則是多少時,才會使X的變異數為0.2 ? o 5. um > 某零件鍍層的平均厚度屬常態分配(N=1.75 O=0.05 um),當厚度規格 設定在1.6um與1.95um間,則產生1萬個零件中有多少個不合格品?

excel統計，求解🙇‍♀️🙇‍♀️

1900 段落 字型 日自 重装使 用檔案 貼上 若 组赛重覆使用檔案 剪貼強 - = 年 假設甲乙兩高中歷年來畢業生的升學率剛好一樣都是:大學50%,技術學院 40%,落格 10%。中校今年共有500位畢業生,其中考上大學者佔56%,技術學院佔30%,落榜估 1。之只有0位畢業生,和中校一樣,考上大学也是佔56%,技術學院佔30%,落 情專屬。 - 。 ELE 就位而言,在0.05顯著水準下,可否言语今年的情形和歷年不同” (2) 說之校而言,在0.05 顯著水準下,可否帮今年的錄取情形和歷年不同? 3.從上述结果,你得到什麼樣的結? Ans : - (1 (1) p = 5.8 x 10 1,遠小於0.05 庭客水準,因此不同。 >= 0 ,,强大於0.05 露著水波,是並不同 走 研究者调查曼要生訓会头,会習的態度,得到了表的為果:

請問學過測驗學或英文很強的大神，我用紫色畫起來的這段話該怎麼翻比較正確

110 95 63 Performance Are Motor Concepts Language Total ite socioeco indings n these TAL-3 itely v eads 89 104 Self-Help 77 88 Social-emotional Self-Help TAL reate esti ifies ess: nor wh 65 Temir Focial-emotional acc ch "F te er 0 H-1510-09 * 3. 5 PAPER+COPY+FAX 雙頭螢光筆 as the Early Screening Profiles, Differential Abilities Scale, and Peabody Picture Vocabulary Test-IV. A recent study favorably evaluates the con struct validity of the DIAL-3 through confirmatory factor analysis (Assel & Anthony, 2009). As noted the instrument was designed to screen for devel opmental delays in three domains: motor abilities, conceptual knowledge, and language competence. An essential feature of the test is that separate scores are reported for each domain. These domains and the 74 fubtests comprising them were rationally precon- derved by the test authors. An important question is whether the 21 subtests “hang together” statistically in a manner that supports the rational grouping into the three domains provided by the test developers, In other words, do the three domains possess a latent reality, or are they merely figments of the imagina- tions of the test developers? Using test results for 1,560 children ages 3 to 6, Assel and Anthony (2009) found an excellent fit between the three domains tra- ditionally reported on the DIAL-3 and three empiri- cally derived domains found through factor analysis, which supports the construct validity of the test. However, these authors did note that Articulation subtest was a poor index of language compe Cotchine subteet

#excel #統計學 想詢問有人知道該如何將「多列」數字的excel轉為「單欄」數字嗎？ 我自己轉置操作想變「單欄」卻變「多欄」 QAQ

3 約繼續十 - 統計變數 . 73 表3.11 參 繁 等等 %蒙 多姿多 多多 学。 蒙”。 等等。 要 婆多錢 多多 MAX XV 多多多多x *MAX(A1:15) E 56.7 59.4 62.1 65.7 55.9 $5.9 56.2 多多 3 $7.2 57.6 58.9 99.5 59.8 4 60.3 60.5 60.6 60.8 61.4 61.7 61.8 62 64.6 大会 $5.7 55.8 63.1 63.6 67.1 * MAX 一意义 日文 素、 II P25 | 61.386 60.9 559 $73 SCAT: 多多 多多多多 15 Q3 16 17 28 Tutz