Trending on TikTok

Buldak

Sunscreen

Sanrio

English

{{sellerTotalView > 1 ? __("sellers", {number: sellerTotalView}) : __("seller", {number: sellerTotalView}) }}, {{numTotalView > 1 ? __("items", {number: numTotalView}) : __("item", {number: numTotalView}) }}

View Cart & Check Out

Nickname

Let us know how to properly address you.

Update Your Name

xxxxxxx@yamibuy.com

Account Orders Favorites

Points 0

Coupons 0

Gift Card Balance $0.00

Sign Out

Change Your Zip Code

Inventory information and delivery speeds may vary for different locations.

Location History

We will notify you by email when the item back in stock.

Your email: {{remindEmail}}

Cancel

Jingdong book

精通Excel数据统计与分析

View Cart & Check Out

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

Books Computers & Internet Office Software

Jingdong book

精通Excel数据统计与分析

Name: 精通Excel数据统计与分析
Brand: Jingdong book
SKU: 3118200351
Price: 32.88 USD
Availability: OutOfStock

{{__(":people-members", {'people': item.limit_people_count})}} {{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ item.invalid_price }} {{ itemDiscount }}

Ends in

{{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }}

{{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }} {{ itemCurrency }}{{ item.invalid_price }} {{itemDiscount}}

Sale ends in

Sale will starts after Sale ends in

{{ __( "Pay with Gift Card to get sale price: :itemCurrency:price", { 'itemCurrency' : itemCurrency, 'price' : (item.giftcard_price ? priceFormat(item.giftcard_price) : '0.00') } ) }} ({{ itemCurrency }}{{ priceFormat(item.giftcard_price / item.bundle_specification) }}/{{ item.unit }}) Details

Best before

Currently unavailable.

We don't know when or if this item will be back in stock.

Unavailable in your area.

Sold Out

Details

Full product details

Content Description

《精通Excel数据统计与分析》由简单到复杂，详细介绍了各种统计分析功能在Excel中的实现过程。通过对统计理论的回顾和操作实例的讲解，实现以Excel为工具解决统计分析问题，帮助读者在掌握统计学原理的基础上，熟练运用Excel进行统计分析。
《精通Excel数据统计与分析》共11章，系统讲解统计分析中的各类问题，包含描述性统计、统计图绘制、假设检验、方差分析、回归分析、相关分析、判别分析、时间序列分析、马尔可夫链分析，聚类分析，以及因子分析与主成分分析等。书中选取有针对性的例子讲解具体操作，个别章节还介绍如何用VBA编程的方法来解决统计分析问题。全书知识全面，实例丰富、翔实，操作具体详尽，可使读者轻松入门并快速提高。
《精通Excel数据统计与分析》可供从事数据统计与分析的人员以及想深入了解Excel统计功能的读者使用，也可作为Excel统计学参考书供高校以及各类相关培训班使用。

Catalogue

目录

第1章描述性统计1
1．1列联表1
1．2数据频数分析5
1．2．1频数分布函数5
1．2．2直方图分析工具7
1．3数据集中趋势分析11
1．3．1算术平均值11
1．3．2几何平均值16
1．3．3调和平均值17
1．3．4众数18
1．3．5中位数20
1．4数据的离散程度分析22
1．4．1极差22
1．4．2四分位差23
1．4．3方差和标准差27
1．4．4变异系数30
1．5分布形态测定及分析32
1．5．1偏度32
1．5．2峰度38
1．6描述统计工具42
1．7小结44
1．8习题44

第2章统计图绘制47
2．1直条图48
2．1．1单式直条图48
2．1．2复式直条图52
2．1．3分段条图55
2．1．4误差条图58
2．2线图61
2．3散点图65
2．4箱图68
2．5正态概率分布图72
2．6时间序列图80
2．7小结83
2．8习题83

第3章假设检验86
3．1假设检验简介86
3．2t-检验87
3．2．1t-检验原理87
3．2．2t-检验实例87
3．3F-检验95
3．3．1F-检验原理95
3．3．2F-检验实例95
3．4Z-检验99
3．4．1Z-检验原理99
3．4．2Z-检验实例99
3．5小结105
3．6习题105

第4章方差分析107
4．1方差分析简介107
4．2单因素方差分析107
4．2．1单因素方差分析原理107
4．2．2单因素方差分析实例108
4．3双因素方差分析112
4．3．1双因素方差分析原理112
4．3．2无重复双因素方差分析实例115
4．3．3有重复双因素方差分析实例119
4．4小结122
4．5习题122

第5章回归分析124
5．1回归分析简介124
5．2一元线性回归分析124
5．2．1一元回归分析简介124
5．2．2一元回归分析实例125
5．3多元线性回归分析132
5．3．1多元线性回归分析简介133
5．3．2多元线性回归分析实例134
5．4非线性回归分析137
5．4．1非线性回归分析原理137
5．4．2非线性回归分析实例138
5．5小结150
5．6习题150

第6章相关分析152
6．1相关分析简介152
6．2双变量相关分析153
6．2．1散点图图表法153
6．2．2相关系数公式158
6．2．3相关系数分析工具160
6．3Spearman秩相关162
6．3．1Spearman秩相关简介162
6．3．2Spearman秩相关实例分析163
6．4多重相关及偏相关分析166
6．4．1多重相关及偏相关分析简介166
6．4．2多重相关与偏相关分析实例166
6．5小结170
6．6习题170

第7章判别分析172
7．1判别分析简介172
7．2判别分析实例175
7．3Excel操作及VBA编程解决183
7．4小结191
7．5习题191

第8章时间序列预测193
8．1移动平均法预测193
8．1．1移动平均法原理193
8．1．2移动平均法实例195
8．2回归趋势线预测199
8．2．1趋势线预测方法原理199
8．2．2趋势线预测方法实例200
8．3指数平滑法预测207
8．3．1指数平滑法原理208
8．3．2指数平滑法实例208
8．4季节变动预测210
8．4．1季节变动预测原理211
8．4．2季节变动预测实例212
8．5小结217
8．6习题217

第9章马尔可夫链分析220
9．1马尔可夫链简介220
9．2马尔可夫链分析实例221
9．3VBA编程解决马尔可夫链分析226
9．4小结230
9．5习题230

第10章聚类分析231
10．1聚类分析原理简介231
10．2水域污染情况聚类分析及Excel编程解决234
10．3小结243
10．4习题243

第11章主成分分析与因子分析245
11．1主成分分析245
11．1．1主成分分析原理245
11．1．2主成分分析实例247
11．2因子分析254
11．2．1因子分析原理254
11．2．2因子分析实例256
11．3小结259
11．4习题259

参考文献261

Specifications

Brand

Jingdong book

Brand Origin

China

Disclaimer

Product packaging, specifications and price are subject to change without notice. All information about the products on our website is provided for information purposes only. Please always read labels, warnings and directions provided with the product before use.

View Full Terms of Use

Scan to Share

Add to favorites

{{ $isZh ? coupon.coupon_name_sub : coupon.coupon_ename_sub | formatCurrency }}

Clip coupons

Quantity

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

Sold by JD@CHINA

Ship to

Free shipping over 69

Genuine guarantee

View details

Region

Added to Cart

Keep Shopping

More to Consider

Coupons

Clip Clipped Over

Expires soon {{ formatTime(coupon.use_end_time) }}

Share this item with friends

Cancel

Yami Gift Card

Get this exclusive deal when paying with gift card

Terms and Conditions

Gift card deals are special offers for selected products;

The gift card deals will automatically be activated if a customer uses gift card balance at check out and the balance is sufficient to pay for the total price of the shopping cart products with gift card deals;

You will not be able to activate the gift card deals if you choose other payment methods besides gift card. The products will be purchased at their normal prices;

If your account balance is not enough to pay for the products with gift card deals, you can choose to reload your gift card balance by clicking on the Reload button at either shopping cart page or check out page;

Products that have gift card deals can be recognized by a special symbol showing 'GC Deal';

For any additional questions or concerns, please contact our customer service;

Yamibuy reserves the right of final interpretation.

Sold by Yami

Service Guarantee

Free Shipping over $49

Easy Returns

Ships from United States

Shipping

United States

Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

Yami is committed to provide our customers with a peace of mind when purchasing from us. Most items shipped from Yamibuy.com can be returned within 30 days of receipt of shipment (For Food, Beverages, Snacks, Dry Goods, Health supplements, Fresh Grocery and Perishables Goods, within 7 days of receipt of shipment due to damages or quality issues; To ensure that every customer receives safe and high-quality products, we do not provide refunds or returns for beauty products once they have been opened or used, except in the case of quality issues; Some products may have different policies or requirements associated with them, please see below for products under special categories, or contact Yami Customer Service for further assistance).
Thank you for your understanding and support.

Learn More

Sold by Yami

Terms and Conditions of Yami E-Gift Card

If you choose “Redeem automatically” as your delivery method, your gift card balance will be reload automatically after your order has been processed successfully;

If you choose “Send to Email”as your delivery method, the card number and CVV will be sent to the email address automatically;

Any user can use the card number and CVV to redeem the gift card, please keep your gift card information safely. If you have any trouble receiving email, please contact Yami customer service;

Yami gift card can be used to purchase both Yami owned or Marketplace products;

Yami gift card will never expire;

Yami gift card balance does not have to be used up at once;

Return Policy

Gift card that has already been consumed is non-refundable.

Sold by JD@CHINA

Fulfilled by Yami

Service Guarantee

Free Shipping over $49

Easy Returns

Ships from United States

Shipping

United States

Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Sold by JD@CHINA

Yami-China FC

Service Guarantee

Cross-store Free Shipping over $69

30-days Return

Yami-China FC

Yami has a consolidation warehouse in China which collects multiple sellers’ packages and combines to one order. Our Yami consolidation warehouse will directly ship the packages to your door. Cross-store free shipping over $69.

Return Policy

You may return products within 30 days upon receiving the products. Sellers take responsibilities for any wrong shipment or missing items. Packing needs to be unopened for any other than quality issues return. We promise to pack carefully, but because goods are taking long journey to destinations, simple damages to packaging may occur. Any damages not causing internal goods quality problems are not allowed to return. If you open the package and any quality problem is found, please contact customer service within three days after receipt of goods.

Shipping Information

Yami Consolidation Service Shipping Fee $9.99(Free shipping over $69)

Sellers in China will ship their orders within 1-2 business days once the order is placed. Packages are sent to our consolidation warehouse in China and combined there. Our Yami consolidation warehouse will directly ship the packages to you via UPS. The average time for UPS to ship from China to the United States is about 10 working days and it can be traced using the tracking number. Due to the pandemic, the delivery time may be delayed by about 5 days. The package needs to be signed by the guest. If the receipt is not signed, the customer shall bear the risk of loss of the package.

Sold by JD@CHINA

Service Guarantee

Free shipping over 69

Genuine guarantee

Shipping

Yami Consolidated Shipping $9.99(Free shipping over $69)

Seller will ship the orders within 1-2 business days. The logistics time limit is expected to be 7-15 working days. In case of customs clearance, the delivery time will be extended by 3-7 days. The final receipt date is subject to the information of the postal company.

Yami Points information

All items are excluding from any promotion or points events on Yamibuy.com

Return Policy

Download the Yami App

Feedback

Back Top

Reviews{{'('+ commentList.posts_count + ')'}}

Have your say. Be the first to help other guests.

Write a review

{{i}} star

{{i}} stars

{{ parseInt(commentRatingList[i]) }}%

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

No related comment~

Load more reviews

Review

{{ showTranslate(commentDetails) }}Show Less

{{ strLimit(commentDetails,800) }}Show more

Show Original

Show All

{{ formatTime(commentDetails.in_dtm) }} VERIFIED PURCHASE {{groupData}}

Please write at least one word

Comments{{'(' + replyList.length + ')'}}